If you don't afraid of ugly representation (which actually can be fixed with CSS) you can use fossil-scm which is used (and written by the same authors) by SQLite. It is just a single executable file. It's comes not only as SCM, but has embedded WiKi, ticketing, email notification...

I've used Spiceworks self-hosted back in the day. Not sure how good it still is.

Github issues?

https://trac.edgewall.org/

First, have a look at these pages for some ideas:

• https://github.com/driusan/PoormanIssueTracker

  A simple format for using the file system as an issue tracker

• https://github.com/driusan/bug

  Distributed bug tracking with the filesystem and hg or git, written in Go

• https://www.joelonsoftware.com/2000/11/08/painless-bug-tracking/

  Nice article by Joel Spolsky about setting up a small bug DB; might also be suitable for use with a spreadsheet

Have you ever used Midnight Commander or a filesystem browser? If you're comfortable finding your way around a directory tree, here's a quick and dirty example with your tickets under a folder called "issues":

FILENAME                            CONTENTS

+--issues
|   +--mom
|   |   +--2023-1128-wifi
|   |   |   +--1-title              Cannot connect to youtube
|   |   |   +--2-computer           iMac, Mac OS 9.0, 128M RAM
|   |   |   +--3-description        Mom said the wifi won't let her out.
|   |   |   +--OPEN                 [empty file, not fixed yet]
|   +--pop
|   |   +--2023-0725-browser
|   |   |   +--1-title              Cannot display my favorite site
|   |   |   +--2-computer           Alien laptop, Windows 11
|   |   |   +--3-description        Firefox is crapping all over itself.
|   |   |   +--FIXED                [empty file, shows all good]
|   +--sis
|   |   +--2023-0901-ms-word
|   |   |   +--1-title              My thesis is ruined!
|   |   |   +--2-computer           Dell Desktop, Windows 10
|   |   |   +--3-description        Word just mangled a file.
|   |   |   +--OPEN                 [empty file, not fixed yet]

You don't need a bunch of separate files; I like directories in case there are screenshots, email messages, etc. Something like this would also work using (say) dokuwiki.

I use Vikunja

Not exactly the same use case, but I use Vikunja for task management.

I've tried a few self hosted options for this, the best so far was Zammad (can host via docker)

That being said I'm also using the free version of Atlassian Jira & Confluence. The free Jira allows multiple projects and then you can use kanban or whatever type of flow. That's to be honest maybe the easier to manage as the mobile app is pretty good and it's easy to setup vs Zammad which took a little bit of tinkering.

There is another one I cant recall the name of now, when it comes to me il add it here but it was probably too basic to be very useful.

Lucky me my family doesn't ask for shit

Best solution, don't help for free. You won't need a ticketing system, because they won't ask.

https://www.youtube.com/watch?v=Kq0BMVhbFkA

We use the Deck app in Nextcloud to manage some kanban boards. Nextcloud isn’t simple by any means but there are docker images or install packages for lots of platforms, including raspberry pi. It’s a pretty “heavy” solution for just kanban but it’s nice for file sharing and access, among other things.

Why not kanboard?

I have used zammad for basically the same thing, looks nice and it's simple.