Ryan, you are right that discussion focuses on the best courses. And that is the problem in the Twin Cities. Braemar, Meadowbrook, Keller, Hiawatha, Gross, Phalen, Brookview. Pretty good daily-fee stuff there just doesn't register.
Some of my favorites are Fox Hollow, Baker, and Majestic Oaks. That said, I would suggest a visitor play any of the great old courses if they could get access.
Playing in MGA events can get you access to a lot of wonderful courses if you are a real strong player. Other than that it is tough to get on them. The MGA has a Chick Evans 7-club deal each year that runs about $250. Maybe it is worth it if that's the only way on to Golden Valley, Interlachen, Minikahda, or White Bear.