Definitely the University of Vermont in Burlington. To me, a top five college town. Very beautiful, downtown right on Lake Champlain, and campus just a ten-minute walk away.
Maybe Smith College (women’s) in Northampton, which is more of a decent size town than a city. It’s a great town, though, and the school is right adjacent to downtown. It is also part of the five-college consortium, which would allow you to take classes, etc. at Amherst, Hampshire, Mount Holyoke, and U Mass Amherst. That might give you some great options for psych and art.
And good recommendations above. I’d second Clark, Holy Cross, Providence, and maybe Fordham (don’t know surrounding area well)
I’d add Tufts, although I’m not sure about art there. Just don’t know.
I agree about Macalester, certainly not New England, but maybe what you are looking for. And New England cold.
Would you consider Seattle/Portland? They may be too far, and travel costs may be too high, but they are some fun college towns with schools that fit your criteria. Just asking.
Good luck!