Reading this thread I see excellent advice. I would say given one of the posts that states what you speculate you would enjoy, a Class C in a campground close to town with a tow vehicle would work (as would other options.) DO check into how expensive campgrounds are in the areas you think you might want to stay. When I was full-timing ten years ago they were pretty inexpensive for monthly rates (and that is usually the cheapest way to go.) I have friends full-timing now and they stay in campgrounds exclusively and the prices are through the roof in many places (especially if you are staying during their busy season.) Monthly rates in some areas are $700 or more. (plus electricity in many.) But, if you have the money to do it, it is the easiest, most comfortable way to break into RVing as it takes the least adaptation.
And it is closest to a traditional home to bring a partner to. You have mentioned the single (and appear to be looking) aspect. For those who don't have this lifestyle, it is perhaps easier for most to feel comfortable visiting if you are in a campground (that is my perspective as a single woman who lived in a Class A in campgrounds who was open to finding a male partner!)
Towing a small car works very well. Just be sure to research whatever car (by year and make) you hope to tow. You want something that tows four on the floor. If you have to get a drive train disconnect on top of a tow package, "it ain't cheap." Also note whether the car requires you start the engine for a few minutes after 200 miles or some length of time. Although it sounds as if that wouldn't be a big deal, it can be. And I definitely would stay away from the added hassle of a trailer for towing your car.
One thing more-- if money isn't an issue, maybe you could rent a Class C for a week or two. That is what is most often available for renting and you will get a good idea immediately of how it feels and whether you feel a C is for you (as much as you can without experience RVing.) There is a big difference (to me) in how a C feels driving (with the cab over) and how an A feels. (I prefer the A, but others prefer Cs.)
As I others have shared-- getting out and doing it is the best way to learn what you want and what will work best for you. What you want now and what you may want in a year may change.
I recall (when I was selling RVs) a couple with two children who were VERY definite in what they wanted in an RV-- a used Class C. I sold them one. Then they were back buying a brand new Class A, and she gave me a bit of a hard time for not convincing her she should have bought one to begin with! In another year (after I had left, but we stayed in touch) they were upgrading to a more expensive Class A (something they were sure initially that they could not afford.) Each time she was VERY sure of what she wanted. And that happens to most of us. It takes living in it, meeting the wonderful people out there and seeing where you fit and feel comfortable and what works for your lifestyle. And what feels ultra important now is very likely to change when you actually start doing it.
Don't be afraid to trust your gut and just go for what feels right to you. There is no "wrong," merely another step in the right direction.