Weight is related to enjoyment. I specifically remember having a mid-low tier full suspension trail bike that weighed 32lbs in the early 2010's. Suspension was good, shifting was kinda mushy(shimano deore), and wheels were okay(deore hubs).
A year later or so I ended up getting a used top of the line variant. Full carbon(besides chainstays), internal routing, xt/xtr groupset with a carbon raceface crank, xt+mavic wheels etc 27lbs. It was better. Was it msrp 4-5k better? No, but on the used market it was cheaper then the prior bike I bought new. While being more enjoyable. I found tires mattered more and would have a bigger impact, but a nicer lighter bike was right below that. After that nicer wheels helped too.
Road... I can feel it there but all the bikes are light(to me) and fast so it doesn't bother me much.
I guess I don't really care about listed weight since someone on the internet probably posted it, or at a bike shop I can weigh the bike in person.