I've lived in New England my whole life. There's one Rhode Island town that I love visiting in the fall.
As a lifelong local, my favorite Rhode Island town to visit in the fall is Middletown. There's a local farm for apple picking, a vineyard, and more.