Looking Glass is fantastic. The infamous "eyebrows" can take some getting used to, though.
Another great area to climb is Shortoff Mountain, which is part of Linville Gorge. The hike in is kind of long so it's best to get an early start. Chances are, though, that they'll be no one else around.
I don't really recommend Crowder's, but one thing it has going for it is acessibility.
Also worth mentioning are the loads of climbing areas around Chattanooga, TN. T-Wall is amazing! Foster Falls is a great sport climbing area.