For anything self-hosted or torrents/debrid, just get a Raspberry Pi with LibreELEC.
If you use Netflix and the likes, you will likely want something officially supported. My partner likes Netflix for some reason and after years of using the unofficial addon by CastaginaIT, I gave up and got her a Firestick this winter (having set up a separate VLAN for it and ripped out the microphone, of course).
The unofficial Kodi addon is an amazing piece of reverse engineering work, but it's not really great that you have to log in using your computer every month or two, and occasionally download a 2GB binary, before you can watch a movie on Netflix half-asleep.