Most of the Tahoe and Liquid Glass related gripes are overstated or sometimes just against the idea of changing anything well-established

I disagree. I generally don't get too upset by UI changes - having been programming since before Windows I've seen many of them - but LG is a loser.

I upgraded my mac to Tahoe and I don't like any change to the UI that I have noticed.

I upgraded my phone the other day, thinking it was just an update to whatever it already had, and ended up with LG on there and it is a disaster. I enabled the 'more opaque' feature and it did almost nothing.

LG is an awful experiment IMO. I'd put it at worse than Vista (which I skipped) and Gnome 3 which didn't bother me because I don't expect anything from linux desktops. I also skipped Windows 8 so not sure about the ranking there. But I'd say it's that level of disaster.

From a company that spent decades harping on about taste, usability, human interface guidelines etc, it’s a train wreck. If Microsoft did it you’d just shrug your shoulders and carry on with life because good taste and usability was never a core promise.