I ended up getting the Toyo Open Country ATIII tires as recommended by some of the posters below, and my tire shop! These seem to last longer than some of other options I was looking at, and don't need rotation as frequently. They're also rated as all-season tires, which is a nice plus for New England.
So far I've driven them offroad quite a bit in VT on the NE BDR, some trails in NH, and out on the beach at the Cape Cod National seashore. They've handled it all very well.
As far as road manners go, they are nice and quiet, but of course they are a slightly louder than highway tires. nothing obnoxious. They've also done just fine with grip on wet asphalt, and are fine on dry asphalt as well. I don't think they are as responsive as the HT tires were for steering on the road, but they track nice and straight.