Tommy,
I think it might help to broaden your definition of are they all that good to maybe “all that good” means having a dramatic impact on golfers or means saving a golf course from being turned into a Walmart or means creating an experience that attracts golfers and doubles the number of rounds or means making the course a profit center instead of a cost center, …. If that is what “are they all that good” means, then there are countless examples of this kind of success and there will be many more opportunities out there in the years to come.
We mostly focus here, as you imply, on the high profile and generally mega budget courses that might make some list, but the real game changing work (no pun intended) that is making the biggest difference to the most golfers is happening on the much lesser known courses. If for example an architect can help save a course from extinction and make it an asset for the local community, that is work that is really good for golf. Creatively taking a course from a Doak 2 or 3 level to a Doak 4 or 5 with a very frugal budget might not make the front page of Golf Magazine or any Top 100 list, but it likely will have more impact to more golfers especially those hundreds or even thousands who regularly play the course because what was done was “really that good” 😊