Avalanche Press makes up for their mediocre game systems by putting them on utterly unplayably-ugly maps. Even with some decent topic ideas, I can't stand them.
But there are some games where the visuals really make you pay attention to a design you might not have otherwise.
My first thought is anything by Niko Eskubi, b/c his counter art is so incredible.
Similarly, Mark Mahaffey's maps look good enough to hang on the wall. War of the Suns comes to mind as a game I never would've considered until I saw that map. His portfolio includes some game maps he re-did as personal projects, like Crusader Rex and Twilight Struggle, and they're gorgeous.
An example of a typeface that didn't sit well with me was the way the Worthington Band of Brothers series looks.
The vehicle counters in ASL are a cluttered disaster of numbers and symbols.