I'd recommend RI. I lived in New Haven for awhile and our go-to was RI. It was about a 2 hr trip typically. Point Judith seemed prime for longboarding with some other "secret" spots around there.