Never been implemented. It doesn’t exist.
Cables support it but zero devices made it to the consumer market and both devices would need to support it for it to work. It’s a dead standard from another era at this point. WiFi speeds have become so significant that there’s just no reason for the additional costs that would be involved.
I admit if half of the people out there who bought smart TVs started refusing to connect them to the internet and bought streaming boxes instead there might be an incentive for TV makers to try it but no incentive for streaming devices to help them do it and at that point it’s just easier for TV makers to require an internet connection or the TV doesn’t work.
If you just don’t like ads AppleTV works great.
That said if you’re set on something less locked down you might look into Dune-HD boxes. They have some that have a dual OS. One is Android TV (not sure how mod-able) the other is Linux that can have other kinds of apps. They’re virtualized and accessible without a reboot. They have great codec support. Just realize only some of their models have the Android TV dual system thing.