@jollyorc If I understand you correctly, you want something like https://www.znuny.org/de or https://requesttracker.com/ which are both FOSS and pretty good at handling tickets.
We are running znuny and before that OTRS for atleast 15 years in the company without any major issues.