Movies set in Connecticut often have the vibe of being stuck between more interesting places (like the Nutmeg State itself).

Cannon Beach is the other spot where parts of The Goonies was filmed (the truck rally scene).