IMHO, we have examples of that in the S.F. Bay Area now, to the point where I'm actually getting up at 0-dark-30 on Sunday to play Spanos Park in Stockton.
Last round was at Metropolitan in Oakland. The Johnny Miller design is good, but they're struggling to grow grass on the fairways now, and it's too frustration to hit a good drive and end up with a ball that's barely playable. Las Positas in Livermore is another course I've enjoyed in the past, but all the recent reviews are that it's a mess.
The courses that are in good shape, like my home course of Baylands in Palo Alto, are now well over $100 for a weekend round, or they don't have much availability, hence my long drive.
Also, one of the victims of the pandemic was the concept of going on standby as a single. Few courses will do that now, and some won't even take a single tee time in advance.