I used this adapter:

https://www.amazon.com/gp/product/B085DJLDBC/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1

...bought it at Amazon. ABLEWE 3-Port USB 3.0 Hub with RJ45 10/100/1000 Gigabit Ethernet Adapter.

And the cable is Monoprice Cat6A Ethernet Patch Cable - 7 Feet - White | Network Internet Cord - RJ45, 550Mhz, STP, Pure Bare Copper Wire, 10G, 26AWG, also from Amazon: https://www.amazon.com/gp/product/B077H45T2F/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1

I did not turn off the wifi when I plugged in the cable the last time, I tried this ...but I did attempt that the time before (and didnt appear to help).

Thanks for your good questions and help...

You are going to have to go android. I will refrain from commenting on apple. I have a Pi 400 but just isn't as good as a dedicated android streimer.

I use the Nvidia Shield, Logitech K830 keyboard. I have kingston SSD in a 2.5" sata external case for cheap storage since had it available. But you want cheep grab a 4k amazon stick or Mi box. You can use an OTG dongle with ethernet USB splitter and have ethernet, usb for storage, keyboard etcetera.

https://www.amazon.com/AuviPal-Powered-Adapter-Charging-Streaming/dp/B07TX8FY6W

https://www.amazon.com/Ethernet-Adapter-ABLEWE-Gigabit-Chromebook/dp/B085DJLDBC/ref=sr_1_3?crid=3PD2YFKRVEPHQ&dchild=1&keywords=usb+3.0+hub+ethernet&qid=1628101471&s=electronics&sprefix=usb+3.0+hub+eth%2Celectronics%2C210&sr=1-3

Powered is what I used.

https://www.amazon.com/UGREEN-Ethernet-Adapter-Converter-Chromebook-dp-B07TWGHM99/dp/B07TWGHM99/ref=dp_ob_title_ce

https://www.amazon.com/Kingston-240GB-Solid-SA400S37-240G/dp/B01N5IB20Q/ref=sr_1_3?dchild=1&keywords=kingston+sata&qid=1628102346&s=electronics&sr=1-3

https://www.amazon.com/Sabrent-Tool-free-Enclosure-Optimized-EC-UASP/dp/B00OJ3UJ2S/ref=sr_1_3?dchild=1&keywords=sata+case+usb&qid=1628102497&s=electronics&sr=1-3

Is this a good one? It looks the same and is 3.0

I have a similar one too, from CableMatters.

I prefer to get USB to Ethernet dongles WITH extra USB ports on it, too. As if it was a USB hub with an Ethernet adapter. I have one for my laptop, since I feel that USB ports are coming at a premium these days for making sure that laptops stay as lean as possible. Lol. :)

Here's some examples: - https://www.amazon.com/Ethernet-Adapter-ABLEWE-Gigabit-Chromebook/dp/B085DJLDBC - https://www.amazon.com/Ethernet-Adapter-uni-Chromebook-Notebook/dp/B0871ZHCKK

These are USB-A male, but USB-C to Ethernet/USB will work great too, if you only have that. Almost all of these should work 100% with Linux.

There's ones you can get with video output, almost like a docking station. Some of those have mixed results of working on Linux. And don't expect too much power delivery with these, too. :(