I like Jira. The UX is good, allows for easy editing and customization. Then Jira Query Language enables good filtering and using it as a back end for custom front ends.

In my eyes it's like a phpMyAdmin specialized for ticketing with an interface which is good enough to not be annoyed when dealing with it.