If you do not like campfires, don't go to "Campgrounds" that have fire rings and permit fires. It's really that easy. Up in the Northeast / Mid Atlantic, the public campgrounds be they State or Fed/USACE, were built to be campgrounds for camping. They all permit fires and all have fire rings. They were not built to be overnight stops for travelers or to be long term accomodations for full timers. They are for the residents of those areas to be able to get out and experience nature. Campfires have always been a part of that experience and always will be.
If you want to "RV", go to RV Parks or Resorts.