Ithaca, New York.
Would compete for the most leftwing college town in America.
Gorgeous countryside, waterfalls, glacial carved lakes, forests.
Wine country.
Because of Cornell, just about everyone in the world passes through -- so enough art, culture, intellectual activity to keep you stimulated.
Glorious summers.
Couldn't be more gay friendly.
Drawbacks: Isolated, and looooong winters.