The 906 is my second "serious" microphone and it does what it's spouse to do: mic up my guitar cab.
It's very straight forward, take an XLR cable, plug it into your interface, set it up on you cab and play!
I'm micing a marshall 1x12 with a celestion speaker, going into a focusrite 2i2 2gen, and it just works.
Worked great so far for both clean tones and high gain, it's a jack of all trades but not really a master of all.
If you are looking for something to mic up a cab for metal, I would go with the SM57 which is cheaper, but won't be as good with the clean tones.
There are better mics out there, but not in this price range that will do all that this mic will do, also the build quality is great, it's built like a solid brick, so you don't have to worry about it, Sennheiser really know their stuff, so they make quality gear.
Besides micing up a guitar cab, there isn't much else you can do with it since it is built with a specific purpose in mind, so it does loose in the features department.
Who is this for? For guitarists that want to record gear demos and don't want to spend too much on a microphone.
Who isn't this for? Metal guitarists that just need something to capture a really sharp and heavy sound. The 906 does low to mid-high gain well, an SM57 will do better with the really harsh stuff.