I've been living in Marlborough for a while and I love it. No matter what part of the city you live in, you're close to something exciting. If you're trying to get around the city though, it's probably easier with your own car than relying on public transportation.
Yes, you'll get your typical New England winters living in Marlborough, but the summers are warm and beautiful. There's a good amount of opportunities for work and school around Marlborough too. If you enjoy the nightlife scene though, Marlborough might not be the best choice for you.
There are plenty of parks though, and some golf courses too if you enjoy it. One of the best areas in the city is Ghiloni Park. If you like barbeque, make sure you check out Firefly's BBQ. You'll regret it if you don't. There's a good amount of opportunities for students and young professionals too since you're in a part of the state that is pretty close to a few other cities.