Wow! Some really good and varied advice touching on all the potential issues. To say just don't do it is unrealistic. There are different lifestyles in RVing and spending your life in a campground is only one of them.
We have only stayed in one for one night so far and enjoyed it a lot and learned a lot. But our goal is to be closer to the action, so to speak, whatever the event/attraction may be. Setting up at a campground and then taking your pick-up/tow vehicle to the beach for the day requires you to do without all the comfort and convenience that you paid for when you bought the RV.
I would hope that we have the common sense to choose carefully where and when to park for the night, we already felt uncomfortable at a Walmart, resulting in the campground stay. I certainly don't think we will be giving all RVers a bad name.
Apparently, in some communities, just parking one in your own yard takes care of that.