Newport, Rhode Island has everything a photographer could want... Incredible sunrises/sunsets, beautiful mansions, a cliff walk with unbelievable views of the ocean, harbors everywhere, a rustic main street, and the list goes on and on. If you haven't had the chance to go to Newport, I highly recommend it as long as you don't mind walking a lot.
The mansion tour is incredible, but is restricted to exterior photos only. To see the sunset during the summer head to Brenton Point State Park. The sunrises behind Newport unfortunately, but the best view I found is at the rock beach by Freebody Drive looking towards the Claiborne Pell Newport Bridge.