Here is a collection of some great snare drum comparison videos. I've been shopping around and I'm still not sure which I'm going to get.
Lots of Ludwig, Rogers, and Pearl snare's in that one - including the Acrolite (I own one), and two Supraphonics.
Here's a more modern video featuring many Mapex snare drums.
And, here is a great comparison of many different companies.
Hopefully this will help get you started. I know I just feel a bit overwhelmed!