I went to undergrad in Waltham. It's not awful. I used to drive several times a week to BU from there, it's a pretty easy drive down comm ave but there are a few ways to do it. Parking can get expensive. You could take the commuter rail in, or park at riverside which is the end of the D line and very close to waltham.
There is a great Indian place on Moody St., by the way.
Thanks for the advice. I haven't got a chance to explore Moody St. yet, though I went to a pretty good Mexican place.