Another vote for New Haven area. We're in the same boat as you and there is a ton going on, both during the day and at night. Lots of bands come through town if you like music, a few different theater options, great restaurants and several museums. Feel free to DM if you have any questions!