Are there any numbers of how many of the users like it, compared to how many users struggle with it? I can't imagine that a majority of Jira users likes it, as that's not my experience. I have met very few people (mainly project managers) so far, which believe that Jira (and other Atlassian products as well) are great products.
I first started being annoyed by it when I joined a large corporation with a central department that would enforce specific workflows and processes. Now I can't move tasks into a sprint without assigning them to a person first, can't move task from status x to y and have a 100 custom fields in there. It's no fun anymore. At the same time the projects are owned by project management and it doesn't feel like home anymore. Where I initially opened up my Jira Board first thing every morning it now has become a chore.
At the same time I have to say that I kinda understand where those processes come from. I now work in an industry where accidentally using a wrong issue type or forgetting to assign issues to specific code changes can become an actual issue due to traceability requirements mandated by law.
Not tense at all. You'd be surprised at how many people actually like Jira, mainly because of how customizable it is. That in my opinion is it's biggest boon and its greatest curse. Every Jira instance is so different it's hard to compare between them. Stock isn't bad at all and works quite well. There are performance issues for sure, but I've yet to see a competitor that has the level of complexity Jira provides do so at a significantly faster speed.
For what it's worth, culture wise Atlassian was great because of how not tense things were. A lot of that is the Australian values in the company. It's very much work-to-live rather than the live-to-work of most Bay Area companies.