My son is a junior. Originally he was sure that he wanted a school with Division 1 football/basketball, etc. When he went to an Admitted Students Day in April and met the other prospective freshmen, he chose Emory. He still hangs with kids that he met in his freshman dorm (Raoul). Every Sunday there were about 8 or 10 guys in his room watching football. Never joined a frat.
He Uber’d into Atlanta often. As bernie pointed out, some of the more fun neighborhoods in terms of coffee shops, music, bookstores, etc. are very accessible.