**** Is more detail always better if not unnaturally bright or fatiguing? ****
YES!
The problem is that perceived “detail” is often precisely the result of “unusually bright or fatiguing” sound. In my book that is not more detail. That is a distortion of the natural sound of musical instruments. The entire frequency spectrum is affected by exaggerated upper frequencies. More natural detail means more music and not only in the frequency domain. Excessive (distorted) high frequencies can alter the perceived overall rhythmic relationship of performers. In my experience more perceived natural detail is achieved by lowered noise floor, tonal refinement and reduction of grunge in the overall presentation (purity of sound). This does not have to be accompanied by more highs.
As @noromance points out the tricky part is how the information (detail) is presented.