https://www.timeout.com/usa/travel/waterfalls-usa
The city tweeted this article today.
I think Brasstown Falls is the best in SC with Issaqueena close behind. Reedy River Falls is the best for city people because there's no other option in the US within a city central business district to my knowledge.
My ten favorite waterfalls:
Hemmed in Hollow - In the Arkansas Ozarks, short hike off the Buffalo River to break up a kayak / canoe trip. Will get wet, only good after recent rain.
Elowah Falls & Upper McCord Creek Falls in Oregon's Columbia River Gorge - Elowah is the second tallest in the gorge and is as nice as the popular and crowded nearby Multnomah Falls. Best easy trail in the Gorge along a cliff with views of the river with a second small waterfall at the top.
Vernal Falls in Yosemite - Will get soaked, epic in the spring during snowmelt. The Mist trail is top 2 hike in Yosemite.
Noccalula Falls in Gadsen Alabama - Walk behind large volume waterfall with some history in a city park
Northrup Falls, Tennessee - walk behind, nice hemlock forest
Yahoo Falls, Kentucky - walk behind in Big South Fork National Recreation Area, trail includes a natural arch
Silver Falls State Park in Oregon - Trail of 10 Falls, four of them are walk behind. #7 best trail in the country on AllTrails.com. Most crowded state park I've been to.
Yosemite Falls - tallest in North America
Ruby Falls, Chattanooga - in a cave, tallest and deepest underground waterfall in a cave open to the public
Dry Falls NC - best walk behind waterfall in the Carolinas, popular but limited parking