Earlier quoted context omitted.
You can make it as useless and as powerful as you want. I have worked on many projects and developers loved it (no joke). But it was down to having it properly setup and using just the bare minimum that enabled to do work. What often happens, is that JIRA "experts" (usually incompetent PMs or Scrum masters) let JIRA dictate your workflow. That's where discontent arises. (No affiliation to Atlassian).
You can make good workflows on Jira, yes. That doesn't fix the horrible UX, sluggishness, confusing options, forms that present a lot of useless fields but don't give you the option to present other, more useful ones, ... I could go on. Jira is a terrible tool.
The UX on modern JIRA has been fine for years, and the options and forms are easy to use. Granted, you can add useless restrictions and weird field configurations, but if someone configures it until it's broken, that would be on them, not really on the product.