Providence has turned into quite a nice little city. the Waterfire events during the summer are something to see. Federal hill has some great Italian restaurants. Taking a walk around Brown University to see the architecture are just a few.
Late to the party, but there's thing in narragansett called romancing the rails, quite nice...get to drive about and everything...they even offer a helicopter ride, quite lovely.