Scup are plentiful all along the southern Massachusetts and RI border.
If you have a small craft, even a row boat, you can row out about a hundred yards. Drop an anchor and bottom fish.
They love clams or any shellfish meat. They are fun to catch and put up a nice little fight on fresh-water tackle. When I go out with my friends out of Fairhaven, we'll catch them, cut off their fins and then live line them as stripers and blues will eat them.
Any place off a jetty if you don't have a boat should work in the warmer waters in Buzzards Bay and of course Rhode Island. More fun than scup though, on the same bait, would be black sea bass. They live in the same waters, are heavier, and put up a whale of a fight on light tackle. Tautog are also a nice fish. This is all bottom fishing with clams, seaworms, mussels, squid, etc.
Good Luck