+1 @whart -- exactly right.
No, more and more and more detail isn't good. It quickly becomes unnatural.
The test is simple:
1 - Remember a time when you heard unamplified live music in a well designed acoustic space (classical in a really good room is ideal for this): or live amplified music in a good space where it just sounded well balanced, no peaky/shreaky headaches, bass overwhelming other instruments, etc.
2 - Remember the "detail" on that occasion? You probably don't. That's because it was just there, correct and in harmony with other aspects of the sound. If "detail" jumps out in live music experiences, there's something wrong with the room, the board settings if amplified, or maybe you're sitting too close/too far from the music.
In reproduced music, I used those examples as acoustic comparators. If the detail within the music I hear from the audio system is even in the ballpark of those events, I'm OK with it. Then it's on to other things that are even harder for even good audio systems to get really right: dynamics (impossible to match the real thing), tonality/timbre, soundstage, etc.
In my decades in audio appreciation, excessive, "hyped" detail is a constant annoyance that someone is always espousing to me as the best thing. It never is. It never sounds real or anything even close to real music.