I have a 28ft Jayco Jayflight that I pull with my F150 (well within weight limits, so I don't need the weight police)... anyhow, my TT model is a 24RKS, but the actual length from tongue to bumper is 28ft.
I am in Georgia and traveling in the east, I have only run into a couple of places that I was too long for. I have run across another few sites that I didn't have backing skills to get into because of trees near site. Even the parks that have some sites that have 25ft max, the park has other sites that are larger.
I think if you get a light weight trailer with a 20-25 ft box size, you should fine. Be sure you get an electric tongue jack and use it when you hook up and you will find hooking up is not as painful as you remember. Also have stabilizers attached that you can use a cordless drill with, much better than trying to get the square jacks lined and the trailer level.