As for hotels vs cops:
In general, hotels will not give up a guest, unless there's a warrant. However, a cop can get a warrant quickly nowadays. Frankly, hotels toss more "guests" than anyone realizes for violating the room agreement.
Also, most hotels will not rent to cops because of "risk" to other guests (see insurance company closing comment below).
Stings occur in hotels that are locally owned that for some reason cops have an angle to lean on the owner.
In closing, what do you think the hotels insurance company position on this is? It's simple, not allowed. Seriously, do you think cops will actually check their weapons at front desk?
Conclusion:
Play smart, do your reference checks, and do not be the low hanging fruit that LEO is happy to collect.
Note to Erica:
Friendly Fire....