I’ve tried various stems.
For my type of riding -anywhere, everywhere, all kinds of terrain and trail, enjoying both slow and fast technical riding. I’m not an XC racer.
I’ve settled on 60mm for both my hardtail and my full susser. I have the (28″ wide) bars slightly higher than the saddle.
(I also have my seats quite a long way forward on in-line posts to get my knees over the pedals, so I wouldn’t want the bars any nearer to me. A bespoke frame for me might have a steeper seat tube and a longer top tube)
This puts me in a fairly neutral position that keeps the weight off my wrists. I find this position good for allowing me to keep my weight on the pedals, making gentle bar inputs and for shifting my weight around on technical/downhill sections.
This arrangement is fine on climbs if you pedal fairly smoothly.
-Importantly, I also find this very comfortable.
Choose a stem to suit you and your riding, don’t worry about fashion. I used to use much longer stems, but far prefer the 60mm.