This is easy for me: Warwick. It seems to get shit on a lot, but it's got a ton of really attractive waterfront; a surprisingly large number of excellent parks (Goddard, Rocky Point, City Park, etc.); a number of excellent residential neighborhoods (Cowesett is my favorite in the entire state, Buttonwoods Beach is amazing, Potowomut, I could go on); the best big-box retail strip in the state terminating in the state's second largest mall; half of beautiful Pawtuxet Village.

People seem to put it down because of a few dead strip malls and mediocre schools (though people also say they're moving to Cranston for the schools, which are ranked essentially the same), and nobody likes living near the airport (though it can be really convenient, including commuter rail to Boston). I've lived in four places in my 10 years in RI and three of them have been in Warwick, and that wasn't an accident.