+1 to what Raquel said. Know who you are visiting well. That is your best line of defense against getting caught.
That aside; Its legal to visit someone in a hotel/motel. People do it all the time. Its legal to have sex in a hotel/motel. People do it all the time. People come and go all the time in hotels/motels. Its normal and expected. The front desk may keep an eye out for people that do not fit so knowing the provider does not go in dressed as a street walker is important. But they expect people they do not know to be coming and going.
Fitting in and acting like everyone else is the best way to not be noticed. Lots of guys coming and going for an hour at a time at an appartment or home is FAR more likley to be noticed by neighbors because its not normal behavior. As for cameras, yes, most hotels/motels have them. Now a days, lots of home and apartments have them too so your very likley on someones camera if you got to a home or appartment as well.
If your being set up for a sting it does not matter where you go. Looking like you are doing the same things as everyone else around you will lower your visablitly.