A few of those were clearly designed specifically for tournaments, but if you want to focus on just the last 20-30 years, nobody has done it better than Pete Dye.
I think many of his courses are hit or miss, and often in the eye of the beholder. Kiawah Ocean I think is great. I personally prefer PGA West to TPC Sawgrass. Of course there is Hilton Head and many many others... Alice Dye's name certainly always comes up in conversations when talking about how playable Pete's courses are for daily play, however, none of these were built to hold the amount of rounds they actually get now. I doubt Harbor Town's greens for example would never have been built so small if they knew how popular the place would be.
Certainly many others have been asked to design for tournament play, but its rare that they 1, are elected to host, and 2, turn out as interesting golf courses for people like us. (I'll think of some examples tonight.) In my option it seems like when presented with this task, to often the design becomes formulaic rather than artistic. Greens, and thus strategies are sometimes compromised for additional pin placements at 2-2.25-2.5%, not to mention the length. I've been a part of 2 projects (1 planning, and 1 construction) where decisions were made to promote easier fan/player circulation and grandstands, rather than the best golf.