I’m on the same page with @golftoursoregon @pushdraw and @country35 . Pinehurst also includes a slight chance of Hurricane action in the summer timeframe too (earlier, like June, is safer and longer days too). With Bandon, one of its negatives (its only negative) is how long it takes most to get there, seems like you got a hike regardless of where you land! So I’d give Bandon the lean over Pinehurst for the summer trip.
Keeping (slightly cooler) temps for Summer options in mind, a couple other options:
I know the NLU boys were not high on Whistling Straits - but I really enjoyed it, but similar price point concerns that Bandon has exist here as well. The Irish is a significantly underrated course in America, and Blackwolf Run gets overshadowed a bit based on the attention Straits gets. Its probably a better course that Straits, but without the dramatic lakeside views. I had way more fun on Irish and Blackwolf, than I did getting beat up on Straits!
Staying in Wisconsin, I just wrapped a Sand Valley/Lawsonia trip which was an absolute blast. You can add SentryWorld into that or add Erin Hills to your arrival or departure day agenda too (as you could with Straits as well).
Northern Michigan is awesome in the summer too - Forest Dunes + Arcadia Bluffs is an awesome pair and plenty of other courses around Traverse City to fill a trip as well. Might not be a “quintessential America golf trip” but was one of my favorites for a summer location if avoiding the hot humid south (where, frankly, more of the 4-5 day trip targets exist).