I'll freely admit that I'm not too proud to go get motel room when the weather is lousy miserable, or the security and safety of campgrounds is questionable. That is especially true if you have to claw your way around or through an urban area.
Typically the pattern I'll find myself in is that one night out of four or five is in a motel or other similar scene (like a hostel). But I'll try to be fussy and get the best arrangement possible: that includes (1) they allow my bike in the room, (2) guest laundry, (3) ground floor rooms, and (4) a generous breakfast. Also, some motels are starting to market themselves as "bike friendly" and this can mean various things, but usually that means that some basic tools and a work stand are available to guests as well.
When I stay at a hotel I also stock up on the little bottles of shampoo and body wash, because those are basically unavailable in campground showers.
Some lodging is kind of iconic with cycle tourists, e.g. the Spoke'n Hostel on the Trans Am in Oregon. You really ought to plan to stay there on your way through.
I also look for lodging that is well located in terms of access to other services, like a bike shop or grocery store. There is rarely much point to any lodging that is a dozen or more miles from either of those. A good example of a great situation is downtown Port Angeles, where there are three inexpensive motels with laundry about a block from a Safeway and a decent bike shop is about three blocks away.
One perennial mystery to me is that some "bike friendly" areas, notably the San Juan Islands in Washington, all have lodging situations that are very much not cyclist friendly, very few have guest laundry, and most of them are wildly overpriced.
Private campgrounds and RV Parks can be a mixed bag, somewhere between wildly luxurious and secure and a complete waste of your money and time.
Shoulder season rates can be a fraction of what peak season rates can be.