PVD used to be my home airport when I lived up in Framingham. Now that I fly back to Cambridge for work, I fly to PVD about half the time and BOS about half the time, depending on the fares.
I think Green is a fine airport, I just wish that they had space for airport club facilities.
American flies to ORD/LGA/JFK, and United flies to IAD as well as ORD.