This is all really subjective, so be forewarned. Nevertheless I had the same questions last year that you and many others will have this year so I will try to be of some help as people on here have been for me.
In general the big name northeast programs are centered around Boston and NYC. Boston has the Harvard programs, Mass General, The Brigham, and BI. NYC has NYU, Columbia, Cornell, etc. There are other good programs in each city, but the big names center around, well big names.
It's interesting that you are looking outside of the cities, I did the same thing intitally. I thought that lower cost of living, less hassles, would lead me to a country program. I interviewed all over and by the end I was having fun in the cities. I'll be going to Boston in 2005 (and couldn't be happier about that) when at the beginning of applying I thought it was out of the question. Point is, you may change your mind so apply broadly.
Now for out of the city programs...
URochester is very good, smaller city, very solid all around with great residents.
Penn State doesn't get much smaller of a city in Hershey. I thought it was pretty awesome there. Very modern facilities, one of the nicest hospitals I've been in.
UPittsburgh is very good as well. Decent sized city but not huge.
I know Dartmouth is not in a big city. I didn't interview there so I know nothing about it, but I'd check it out.
Now if you're willing to leave the northeast and move midwest, some very cool small college towns exist (of course I'm biased being from Michigan), but UMich in Ann Arbor is great. UWisconsin in Madison is the coolest small city in the midwest to live. Iowa is very good. Mayo in Rochester MN is in the middle of nowhere but also very good.
And since your locaton says ME, I assume that's Maine. Maine Med in Portland is a solid program that's easily overlooked. I was impressed by the quality of residents and attendings. Most attendings trained at Mass General and migrated north. Nearly all are fellowship trained and I was suprised to find out the cases that they did up there. They seemed to send people to fellowships where they wanted and in good places. Portland seemed like a great place to be as well.