It's not hard to beat the notoriously bad build quality and reliability of the LG UltraFine and Apple has a track record of building solid displays (I have an LED Cinema Display that's going on 13 years old with nary a single issue).
I think your experience has been a constant of most Apple products for the last 22 years or so. Some people have no issues ever, some people have constant issues all the time. That said, I loved the Cinema displays and they did have a good track record, but if memory serves, the Thunderbolt Display variant was notoriously flaky [0]. Since they've put out so few external displays, it does stain their reputation a bit.
Everything I've heard about the Pro display XDR's has been that all the things like USB/Thunderbolt connectivity are rock solid.
This suggests Apple's display group has their goods together, and the Studio Display is likely to be solid too.