The LMA is a great place to start to give you an idea how different mics sound. Even better if you can find recordings of the same show (and hopefully same location, mic pattern, preamp, etc) with two different mics you are interested in to see how they compare to one another.
To me, finding comps as noted above is the only way I ever find any use of surfing archive for sounds. I can make my mic (the BSCS-L in the sig) sound dark and rumbly in the bass or neutered in the bass (ala a neumann) in the same venue for a comparable show. I don't doubt it's possible with other mics as well, so if:
- I don't know the traits of a mic, and
- I don't know how the person did their aiming config (not always listed), and
- I don't know how that room/area typically sounds, and
- I don't know how the FOH/crew tweaked the mix that evening, then
then I'm not really getting an accurate picture of what that piece of gear sounds like. Until I started taping in Richmond at shows where lots of others were (and I clamped to their stands), I didn't have a good reference for what Mic A sounds like compared to Mic B. Even then, since many here use different preamps or recorders, I still don't a great idea, but at least I'm making headway. Now, I look forward to hearing tapes that others made at shows I was at, cause I can compared to the baseline I have (mine), and slowly get an idea of "so, do I want brighter tapes, or darker tapes, or more midrange, or what?" and then go searching through my experiences. However, all of this occurs after I have references to gear I know, thus; surfing archive becomes more valuable as you gain experience, but starting out there is tough (and was for me).
So Todd; I'm not aiming this post at you, this is not intended as an attack on what you've said (I just used your quote for the bolded portion was my intent) I just honestly don't understand why people recommend surfing the archive for comp information that they don't have a reference to.
Personally; I think a better question I would ask the OP would be, "what sonic characteristics do you enjoy, use many adjectives" and draw upon experience here for mics that fit as many of those characteristics as possible and then find sets of those mics to test-drive or at least tapes from rooms I know with those mics.
I've done dumb crap before, so maybe the above is off-base.