The Long Drive and My Summer Car are literally everything you describe wanting in two distinct flavors.
I also was immediately thinking “The Quarry,” which is essentially a playable horror movie set at a summer camp. I don’t usually like these types of games, but this one is extremely good if you like horror movies.