Low tuned and high tuned snares have their places. I don't like hearing a high-tuned, cracky snare in slow tunes. It just sticks out, and I don't find that musically pleasing. Low-tuned snares are a fine line, though, and they do have a tendency to be processed to death, and I don't like that either.
I've always loved the snare sound on Dream Theater's Live at Budokan. The 14" snare on the left side of the kit. It honks, AND it cracks. And there's tons of really wonderful reverb, what sounds like a Lexicon 480L to my ears. (You can find a drums-only version of that album, and the reverb is clearly not coming from just the sound of the venue.) Kevin Shirley's mixes always have fantastic drum sounds, and Anton Fig's playing on various Joe Bonamassa records sounds great too, though I'm not the world's biggest Joe fan.
And of course Joe Morello's whole kit on Time Out sounds exquisite.
And Dogman by King's X is my gold standard for how a rock record should sound.
As to a snare sound that I don't like... Check out Will Kennedy's Zildjian Live performance. His playing, as always, is phenomenal, but the snare is big and fat and fairly heavily compressed (or is that Neve console saturation?), and notes get lost.