This may change when I have children, but my favorite place to have sex is my own bed. I sleep on excellent bedding, and can't afford to stay in hotels with nice linens like mine. Maybe that would make a difference. If I'm there just to have sex anyway, and it must be a hotel, I prefer a place that will rent in four-hour blocks. There, I know I'm not keeping anyone awake when I get loud.
I'm not particularly comfortable having sex in nicer hotels. I once stayed at a resort with friends. We got back to our room after 11pm, and began mixing cocktails. We were laughing and talking, and not particularly loudly, but the father of a family next door began calling us and asking us to keep it down, citing a 7am flight. We made a concerted effort to be even quieter, but when it became clear that only silence would do, I told the man not to fly so early, to travel with ear plugs, and to play static on the radio and television. I informed him that our vacation plans included cocktails and giggle fits, and that we were not going to be silent for him. He threatened to call the front desk and the police, which I encouraged. We heard from neither, which made me all the more certain our noise level wasn't inconsiderate. Imagine if I had been trying to fuck? Nah, if it has to be a hotel, I prefer one to which no one would take a young family and then I definitely don't hold back on the noise, regardless of the hour.