You may be the exception but inertia says you will set up and never hook up and take trips away from that campground.
We know a several couples who said the same thing you are and the rigs never move again, the sites gradually become more and more permantent making it less and less likely they will hook up for a weekend trip.
Absolutely nothing wrong with it (our friends who have done it generally like it) but you would be the exception if you got a permanent site and still traveled regularly in the RV.
As far as general issues:
- Assuming it's mostly permanent sites, it's really easy to get pulled into camp personal drama.
- Do you have to maintain the site (mow the lawn, rake the leaves, etc..) Not a huge issue but eats into that time savings not having to go pick up the RV.