Angus McKenzie had a column for years in "Studio Sound" magazine (U.K.) which was always a worthwhile read. Somewhere I have the image files I scanned from a comparative microphone review that he did in the 1970s, which I would gladly post, except that those microphones aren't available any more today. Still, if anyone's interested just in seeing how it could be done, I'll dig them up. (Edited later to add: Found the article, uploaded it here, and realized that it was co-written with Tony Faulkner--whose work is definitely worth looking up as well.)
But even the best reviews or comparisons can only be suggestive in value. You have to understand the characteristics of your microphones on an intuitive level to use them to the best advantage, because every setup is a guess based on whatever prior experience you have, and whatever kind of result you hope to get.
An experience that I recommend to everyone: Take a recording that you admire and find out what equipment it was made with. Try to get the same sound yourself using the same equipment in the same venue on similar-sounding music. I think you'll find that it's surprisingly hard to duplicate someone else's results--because a lot comes down to that last foot or two of distance for mike placement, the last five or six degrees of angle between the mikes, etc., and that's something that the other person decided from their own prior experience and their own expectations and wishes. I did that a number of times in the first few years that I worked as a recording engineer. My recordings pretty much sounded like my recordings while David Griesinger's recordings pretty much sounded like his, and Peter Storkerson's sounded like his, etc., no matter whose equipment we were using.
Moral of the story is that the microphones need to be good enough, for sure, and the smoother and more transparent sounding they are, the more adaptable they'll be to the largest number of situations. But in the end it comes down to the way you listen and the way you actively relate subsequent choices to what you've heard.
--best regards
P.S.: A fellow named Ty Ford has also posted some useful microphone reviews on line in more recent years--maybe you can find those?