The two that I've played that made the lists are pretty good.
The Legends in Prior Lake, Minn. (25-30 min from downtown Minneapolis) is another good course by Gill Miller Architechts. The sixth hole is a long, demanding par 4 (450ish from the back) with water left off the tee and water short and right near the green. The one shots on the back side both have forced carries over water. There's also one short two shot hole (which I like). There's a good variety of holes. Maybe none are spectacular, but none are bad.
The bad about the course is it isn't that friendly to walkers. No benches and with GPS on the carts, they don't think walkers would like to know where the pins are on greens. I don't need a pin sheet, but red, white, blue flags would've been nice.
One nice thing is the Sunday afternoon rates are very affordable (less than $50 if I'm not mistaken).
TPC at Rivers Bend:
I'm generally not a huge fan of Arnie courses, but this was better. There are a lot of trees -- especially for a TPC. There's a good mix of holes and challenging greens. The only drawback is that the closing hole is a bit weak, a short par 5 that lacks character. All in all, pretty good for a TPC and better than the one in the Twin Cities.
I haven't had a chance to play The Summit, a course on the affordable public list. Reports, however, are good.