It seems for many organizations, their CMS is working well for them.

I hope to work in one of such orgs some day because the most common experience I've witnessed was pain.

And things don't improve when you throw more money at a CMS. There's an entire industry of enterprise CMSs (yearly license in five figures) and their users aren't any happier with their CMS than WordPress users.