Year ago, Rocky Gap was good in the fall. SWMBO and I woud go for a week tenting, and have the entire campground to ourselves. I haven't been back since they turned it into a resort with golf course. New Germany was pretty nice back then as well.
What is it about Elk Neck that you don't like? My family goes up there several times a year.
Baltimore county has some nice ones, but check out the Shenandoah. You can also head up to the border near WVA and there are some fun lazy rivers. Look up Harper's Ferry
i go 4 times a year to big dog events in gore virginia. place is called the cove campground's. very affordable fee's and trails abudanza! even got hot showers and multitude's of campsites. i always stay at camp 5.