Back in my boating days, there was a common term used for new boaters that had just gotten into the lifestyle called "two foot-itis", which represented the soon-to-be urge to get a larger boat, being 2 feet longer.
When we bought our first motorhome in 2008 we bought a used 32' Tiffin. Four years later we traded that rig in for another used 34' Georgetown. Then six years later we bought another used Sports Coach 36' DP. We are now at the size that we are content with the size and amenities of our rig. With our first MH, we started without a tow, and being a newbie driving a motorhome 102" wide I didn't have a problem going to the supermarket, around towns, campgrounds (state, C.O.E., and private). The next season we added a rack to it to carry my 1000cc vintage Kawasaki motorcycle with us. Wow, this opened up our exploring of the towns and sights to see wherever we were camping. This led us to buy our first Master Tow Dolly, used for 3 months for $925. It was cheap, easy, and fast for us to load and unload my wife's Toyota Rav4. We put somewhere near 40K miles or more on that dolly without ever having a problem, or having to drop the car and dolly to turn around or back up.
We kept that dolly until a couple of years ago, before our 8K mile country trip. I bought another Master Tow, this one has hydraulic surge disc brakes.
Now towing our Kia Sportage on the dolly and our 36' motorhome, 57' total length, we still don't have a problem going to most supermarkets, big box stores, certainly campgrounds of all types, or take back country roads that maybe Google will direct us vs our Garmin RV GPS. With this setup, there has been only one instance where I had to remove the car to back up after making the wrong turn into a campground where I turned into a closed gate entrance.
I have confidence in my driving ability that I'm comfortable driving just about anywhere with it. So that is my advice to the OP is once you gain your confidence driving a different larger rig, especially if you go with a 28-30 foot class A, you should not have a problem going wherever you want. And, to make that even easier you can look at 26-30 class C's that have a lower height and are not as wide as a class A.
To the post on Super C's, yeah they are pricey. However, there are some models out in the RV world built on the Dodge (err RAM) chassis with the 6.7 Cummins that are super nice and a lot less expensive than the Freightliner models. Added to that are a few Ford 550 chassis models using the Ford 6.7 diesel that are less than the Dodge but still very nice.