I live in Columbia. It sucks... Lol.
No but seriously, it's alright relative to other areas of SC. I chose to go to school here over Clemson because I wanted a city vibe where there were actual movie theaters, restaurants, other things to do, etc. For college it was pretty cool and there's definitely worse places. I can see it making sense if he really wanted to get away from Miami/Florida and wants some weird mix of southern, college town, and city.
To me there should be two choices when it comes picking city vs college town:
1) Full city experience like Miami or UCLA
2) Legit small college town with pretty campus and chill environment like Clemson/Auburn.
Columbia is a weird mix of both and it does neither particularly well. If it wasn't for a nice job here and my girl going to the med school here, I'd be gone yesterday.