I would agree with all of the above. I can't speak for the other programs, but here's my take on Emory:
1. Atlanta:
Pros: good location for me because of family ties, but it's a GREAT place to be for public health. Cost of living is pretty low in comparison to other cities of its size. (My roommate and I share a very nice, 1250 sqft. apartment for ~$600 each). Nice restaurants, nightlife, shopping, etc.
Cons: ugh. traffic. Atlanta is a commuter city, so traffic is awful. If you live close to campus, it shouldn't be too much of a problem. It's maybe not as exciting a place to live as NYC, Boston, etc.
2. Emory professors:
Pros: Very approachable. Everyone has been extremely nice, eager to talk with students. Lots of different research interests among faculty means there's something for everyone, thesis-wise.
Cons: One issue that could be potentially a con is that there's a lot of interest among students in infectious diseases, and I know some people didn't get their first choice faculty adviser because of high demand in that area. (Not a problem for me, since my interest is MCH).
3. Epi program:
Pros: Very nurturing environment. People seem to really want us to do well, and go out of their way to provide opportunities for students.
Cons: No problems thus far. One thing you MIGHT consider a con is that, so far, the courses have not been as academically rigorous as I expected. (I hope I didn't just jinx myself for this semester!!).
4. Miscellaneous:
Pros: Awesome career services department. Job placement among Emory grads is excellent, particularly those that actively use career services. Everyone knows the CDC is here, but it's a tremendous resource for students. I, and most of my peers, work as students at CDC, and I'm using data from the study I'm working on for my thesis. There's also CARE, ACS, Carter Center, etc., LOTS of opportunities here.
Cons: Expense. *sigh* It's private, not much funding available. Oh and parking on campus is $654/year!, (unless you live and work really close to campus a car is necessary; MARTA and a campus shuttle are some alternatives though).
Whew. I know that was wordy, but I know it's a big decision to make too. I hope this helps. FWIW, I, too, decided against BU due to cost, and I'm very happy with my decision to come to Emory.