What I had figured in this past ~10 years since working with Jira: it is not this software that made my life hard but the project managers, administrators etc. who are misusing it.
E.g creating lots of fields with overlapping meaning. Creating very basic/lame status-flows but not enforcing it. Or creating very hard to follow status flows. Or misreading the data from tickets status history. Or never trying to learn how to use it but find the guy at (my) table, to create the queries, dashboards etc. (and then misuse them). Or the devs who were complaining about missing info but creating one-liner comments as well (if at all). Or the devs who are not searching for duplicates, similar issues and/or link them so it can be tracked.
It is far from perfect, and JQL is so far from being intuitive, but I can live with it - until there is a better alternative that is capable AND I have to use that.