Well, if you do go to Newport, let me know...I ride Ocean Drive all the time...
there are a bunch of us here that can give you ideas but if you have never been up here, let us know how much "Riding" versus "Sightseeing". For example, Newport will be crowded depending on the time and I enjoy riding it but it ain't the tail of the dragon.
In NH, you have the Kank and the Mt. Washington Auto Road. You have scenic Coastal Roads and you can ride to Provinceton on cape Cod. There are some beautiful roads through rolling hills in sEastern CT by Gillette Castle and Devil's Hopyard State Parks. Then in Western CT by Cornwall Bridge, Kent Falls and Mohawk Mt. Again, Rolling Hills twolane roads are there...but you do have to occasionally go through cities. Coastal Route 1 in Maine and Rt 100 in VT.
Oh, and if you happen to be considering the week after Laborday, we are contemplating an unofficial/small CVO gettogether somewhere in New England, maybe Wed to Sat.
these are some of my quick Suggestions.
/Bill