Are you flying in to Detroit? NorthWest? I was there a week ago, and there's a store that sells Detroit Sports stuff. I checked WC hats and the prices are good. It's at the center of the Terminal, on your left before you head down the stairs to Luggage Claims.
If it's the Smith Terminal, I'm sure there should be a similar store too.
Good Luck!