You'd be better off being based out of Bradley vs Logab if you can.

Amherst itself pretty much checks all the boxes for things you like.

If your significant other is at Amherst college one car is probably fine, they will be very busy doing school work for the next 4 years. And it's a very walkable area with decent public transportation to shopping if needed.