ive been through this process recently and sadly, what you are looking for doesnt exist at the moment. thr closest thing is Kodi and as you already know, has a lot of flaws.
Its worth noting however this can cause weird problems since its system wide and even network wide if you set it up that way.
As an example, my wifes Spotify podcasts didn’t work for months only for us to discover pihole was blocking the cdn Spotify uses.
ive been through this process recently and sadly, what you are looking for doesnt exist at the moment. thr closest thing is Kodi and as you already know, has a lot of flaws.