I'd question whether a streaming device is really the right option for you. You seem to get extremely frustrated by compromises within windows and a streaming device is by its very nature much more of a compromise.

Many codecs aren't supported, you can't play flash and they don't have a browser. If you can get your head around this sort of stuff and accept that they are good at what they and no more that's great, if not you will hate it.

No one device does everything but an Android device will get you pretty close with apps and Kodi. Personally I run a Fire Tv and an Apple TV 4. Both are good but some stuff is missing from each.