The problem with project management systems is that you have four important levers:
* configurability (enforcing rules, custom workflows, triggers)
* usability of the UI (speed, simplicity)
* multi-user (including consistency between users)
* scale (number of projects, users, tickets)
You can't have all those at the same time. If you want it to be very configurable, you have to choose whether to prioritise scale (Jira), or usability (Trello, Asana), or drop the multi-user (Excel, Google Sheets).
In my opinion, the problem with most project management systems is the problem with project management management itself - trying to do too many complicated things at the same time. It's pretty easy to manage even a fairly large programme of well-scoped projects on just about any software.