We are living in a pretty major metro area, near several State Parks and there are lots of major events in town. We rent about as much as we want to - if we make the camper available, it is generally rented (in season). We do not use Craigslist, nor do we consider this our "business" as much as a side-hustle that basically pays the camper payments.
One thing that you have to consider is that many state parks are starting to crack down on RV rental deliveries. It’s ok if renters take them into the park themselves. But a lot of them are not allowing deliveries unless you have the proper vendor permits.
Check into delivery requirements to your state and federal parks too.
Yes, really depends on location. I am located in Las Vegas and it is rented out enough to pay for itself. I recommend to look at a similar trailer/RV that you have and in the same location. Scroll down to the bottom and most will have reviews. Look at the dates on those reviews and how recent they were. If you find one and see it rented out at least once a month, then you shouldn't have any problems.