Where there is nightlife, there is great way to make new friends in your neighborhood, get to know your town, and otherwise savor the local flavor. (Literally, since the best restaurants usually crop up around drinking establishments, as do the casual dining institutions of the more indulgent breaded and fried variety.) It's entirely possible to be approximate to the center of the action without being kept awake at nights -- and if you're single and/or without kids you may relish just such an option, even if it bumps your mortgage payment up a modicum.
If you’re downtown, as bars so often are, there will likely be a lot more activities by daylight as well: art galleries, shops, craft and activity studios, cafes… and often some of the city’s more venerable and interesting architecture or monuments. It’s all there.