I have a Phantom 4 Pro, never flown over a campground, but have spied on all my neighbors here in English Ranch - take a look!

I've heard great things about the Mavic, and Costco has those and the Mavic Mini, which also takes amazings video and stills.
For RVing, I think smaller would be better for storage and ease of setup. My setup takes some time so becomes a limiter - I don't fly it much.
The CSU Hughes Stadium was torn down since the university built its new stadium. So sad, here it is a couple months before it disappeared forever.

I haven't tried scouting out potential off grid campsites yet and wonder how feasible that would be.
I learned early on with my neighbors, letting them see the screen together with me as I fly alleviated all the 'spy' considerations they have. It just isn't possible :)
FWIW, I'm licensed by the FAA and the drone, of course, is registered. When you shoot it down, look for my business card in the battery compartment and give me a call :p