I usually just reach for Born and Raised or Paradise Valley if I want summer John Mayer vibes. I think the big one you're missing is "Age of Worry," which is a go-to summer roadtripping song for me.
Same, this is me trying to push outside those. One of my plans this year is to make more artist discography playlists. Obviously I could just cue up songs as I go but this is fun!