Ok you explained a little more on your goal, photography, places like Moab, off the beaten track. Staying for a month or so, and then moving on, exploring new areas.
First off, to stay somewhere a month is going to require more water than most rigs, especially small converted vans can carry. Grey and black tanks or at least a receptacle for the waste. And a reasonable means of getting water and removing the waste.
Purpose designed RV's have those aspects built in to varying degrees. But even then, size of your tanks will usually determine how long you can stay somewhere.
Access to back areas is one I have been fighting in my own head, for maximum ability to get into remote areas, a 4x4 truck with a slide in camper will offer the most flexibility, but for a retired couple in my case, tanks and space would be a major limit on out ability to boondock camp, and unless you are jacking the camper off the truck, a run to town requires taking the "house" with you, which means securing and packing everything before moving.
4x4 truck with a small trailer comes next, Can still get into most areas with any type of fire or forest service roads, will have larger tanks allowing a longer stay without hookups and allows easy detaching of the truck to go further into remote areas. Trailers can be as large as you feel you can tow and still get into the areas you wish to visit. Tank sizes can easily get you a couple weeks or more of off grid camping.
As you increase the trailer size, and look toward 5er's as well as travel trailers your ability to get remote goes down as the size of the rig goes up. Need to scout roads to ensure turn around room become a concern.
Class B, camper vans can give you similar freedom to move as the truck camper with the limits being that most are not four wheel drive, and do not have the suspension and ground clearance to allow the same freedoms that the TC guys have.
Larger motorhomes again will not have the ground clearance as a 4x4 truck, with their longer wheelbase will be more problematic on going off pavement, but are still capable on gravel graded roads. Tanks can be large enough to support a single person for weeks at a time. Most have generators aboard for electric production, and have household type amenities.
As to where and how to find places to stay without trying to hide in towns, watch a few you tube video's. One of the members here has a channel called "Grand Adventure" and in one episode details how he finds his remote locations in national forest and other areas.
There are numerous others as well that show different methods for everything from site location to tours of specific areas and how to's on all things rv, from solar to black tank cleaning.
RV's are like the rest of life, everything is a compromise, make the best choices you can, and take all that those choices allow you to experience.