Is north haven ct a nice place to live in? ?

You pretty much need a car.

Currently, passenger trains don't stop in North Haven; the nearest place that you can get on or off a train is Wallingford to the north or New Haven to the south.  There is supposed to be a train station again someday, but only one, probably not near where you live (meaning you'd need to drive to get to the station), and service will be perhaps once an hour, nothing like the NYC subway.CT Transit runs some buses, but it's nothing like NYC.

You can't live anywhere in the United States without a car besides a few places such as NYC, San Francisco, and a few other metro areas. But even in Boston or Philadelphia, Seattle or D C., without a car you're going to have a tough time living a full life. 

Forget living in Connecticut if neither of you drives. Even living in a place like Stamford or Bridgeport would be impossible, never mind North Haven. 

It wouldn't be a good idea to relocate to a place where you need a car if you are planning to learn to drive and don't currently own a vehicle. Not only would it take you some time before you'll be confident and skillful enough to function on the road, but you'd have to chauffeur your husband everywhere all the time, including back and forth to work. 

It's true that there are cabs and Uber to get people where they need to go, but those services aren't as common as they are in larger metro areas and relying on them every day would be really difficult. Stay where you are. Under the circumstances relocating to a place like the one you're considering would be a bad idea.