Amy, given that you are flying in to Providence and leaving from Manchester, you'll probably want to stay in the eastern part of the state. But, for me personally, if you want scenery it is all about western Mass -- Connecticut River valley and the hills of the Berkshires and Route 2 from Greenfield up to Mt. Greylock. In eastern Mass, it'll probably be a great time for a drive around Cape Cod as it is early enough in the season before the tourist hordes arrive. For some scenic towns elsewhere, there's Concord and Lexington, and up on the North Shore I like the Ipswich and Essex area.

Good luck,