In my view, there's no such thing as "extreme detail retrieval". There is just the detail that every recording contains, and from that point you can only go down. The idea probably comes from the particular habit of some components to slightly emphasize the higher frequencies, as an attempt to make the transient sounds stand out over other sounds.
A good audio component or system, should be able to extract all the recording's detail without sounding etched, harsh, bright, metallic, fatiguing, etc. There are NO EXCUSES for this characteristic, it's a flaw. On the same way, many mid-fi products sound harsh, etched, bright, etc. and yet they present considerable detail loss.
Either way, the word "detail" is much more universal than just the higher frequencies or fast musical transients. Yes it can manifest in a cymbal's texture, but also in the organic feel of a leather bass drum. You can find it the breathy quality of a female voice, in a distant voice in an opera stage, in the 3D layering of a chorus. The interesting thing about a good system capable of retrieving all the detail, is that it increases your spectrum of enjoyment. Recordings that you couldn't bear to listen to formerly, now become far more enjoyable, even with their ever-present flaws! DVD movies, even your cable box, can be surprisingly enjoyable. Not to mention your high-performance audiophile sources (CD, DVD-A, LP). These should be absolute heaven to your ears.
If a component is really transparent, it should be musically satisfying in the long term. In fact, I Think that's the mark of true transparency. Unfortunately, many components that are labeled as "musical" are not transparent, showing a fat, dark, colored sound that will become tiresome sooner or later. The choice is yours.
Regards,