"I've been in places that stink of pickle juice, cigarettes in a no smoking room, etc."
Have not had that experience or anything even close to it, except in the back woods of China. The water came out brown in that hotel room and the a/c didn't work on that hot evening.
However, I did not stay there. I went down to the lobby and argued with the hotel manager for 1.5 hours until they got tired of me, like OM, and sent me off to another higher class hotel where everything was in good shape and for not extra charge. I took the position that if I could not sleep, the hotel staff could not relax either.
My recommendation is pick National Chains you have had a good experience in and pay a fair rate for a hotel. If you are paying 2x to 3x the daily rate of an rv private campground, depending on the day of the week, you are on track. Since you are not paying for the cost of an rv, you can pay even more and make that hotel part of your entertainment.
My wife and I plan to stay overnight the next time we travel up California HY1 and stay at Timber Cover Inn at Jenner, CA. The rates there are well over $200 per night. We will stay one night for a two day vacation. That is an exception but it is a very romantic location and beats any $1million rv for one night and the Inn includes a complete staff, excellent wines, and excellent dining. You also have the wonderful option to go up the ocean the first day and come back through a gorgeous backwoods area the next.