Oh, well, this is a tough one. The scenery is one of the main reasons for coming to a campground area, but not necessarily a reason to come to the campground. However, there are a few campgrounds that are mind blowingly epic when it comes to their ambiance.
Clear Creek Cove in Talladega, Alabama, www.clearcreekcovervresort.com has stunning views of Logan Martin Lake from their Mountain Top campsites. These sites offer sunset views over the Lake, the islands and the foothills of the Appalachian Mountains. The Lakeside has beach access to Logan Martin Lake and amazing sunrises.
LiveCampWORX for awesome sunsets and sunrises.