This forum is great. You ask one question and get a dozen or more answers. That's because camping folk love camping (RVing) for all different reasons. But I consider any response more as an opinion than an answer.
So my opinion, I do whatever I can to camp as much as possible. I have a seasonal site where my camper can sit from April until October. Every morning I share a coffee with one of my neighbors and every night someone has a campfire going where we all gather. (This never happens at my house neighborhood). My sons have made friends there as well since we are seasonal. This is something you don't usually get chance to experience when you are a weekend wonderer.
However, we still head out periodically and explore the Nomadic adventures as well. At least once a month we are on the road. It may just be for a weekend. But at least the option is there.
Personally, I believe we have the best of both worlds (again, my opinion). We have great friends at our seasonal site and still explore new places. Our seasonal site is the same distance from work as our house allowing us to stay here as much as we like.
We actually go to work from our campsite.
For the naysayers that think camping close to home is crazy (within 45 minutes), it's a matter of opinion. When you are sitting at the evening campfire, can you tell if you are 10 minutes or 10 hours from home? Of course not. And I never remember thinking of the house when camping.
Yes, we bought new. As one other person mentioned, if there be dirt, let the dirt be mine. And many units were traded in because of some obscure water damage. A big plus is you have all the instruction books and get a good familiarization session with the RV dealer. Just take good notes. And the RV dealer is also someone to call if you run into an issue. But 90% of the time, if you have any issue, someone at the campground will assist you.
Do what feels good for you and your family. Nothing is permanent. If you don't like a choice you made, you change it. And you had a lot of useful info on this forum provided by some good folk.
Enjoy.