Having spent quite a bit of time in both places, New Haven is infinitely better, even before you consider that New Haven is part of the NYC metro area (which honestly makes Greater Detroit look like a small town in Saskatchewan), and close to many other great places.