No I don’t use the Amazon ethernet adapter because it’s junk and Max out at 100mpbs… Here is the set I use…
OTG CABLE: https://www.amazon.com/gp/product/B07ZF6KSTR/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1
USB HUB W/GIGABIT ETHERNET PORT: https://www.amazon.com/gp/product/B0871ZHCKK/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1
CAT6 CABLE: https://www.amazon.com/gp/product/B006JN6PL0/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1
USB 3.0 32GB THUMB DRIVE (For Expanding storage): https://www.amazon.com/gp/product/B081QSHG13/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1
I really like this OTG one because it's small and just plugs in the back without being a cable, just make sure you pick the one going to the correct direction, else you can't plug in a memory stick anymore because the hdmi cable would be in the way:
If you really want an OTG cable get this:
Then just get a good usb-stick, NOT and SD card:
^I like this one because it's small and in combination with the OTG I mentioned first wont stick out further on the side of the console.
Size?
Depends on what you want to put on there. If you stick to 8/16-Bit games 32 or 64 GB should be more than enough.
^This should be more than enough for the stuff you are planning to put on there.
If you are planning on also putting PSX games or so on there go for at least 128 GB.
But hey this is just my opinion, you are free to mix and match.
Also you should have zero C8 errors if you don't put too many games in one (sub)folder.
Here is the setup I have and I’m get around 350mbps....
OTG CABLE: https://www.amazon.com/Adapter-Streaming-Logitech-Keyboards-Nintendo/dp/B07ZF6KSTR
USB hub with Ethernet Jack: https://www.amazon.com/Anker-Gigabit-Ethernet-Converter-Support/dp/B014ZOJX7W
Thumb drive: https://www.amazon.com/SanDisk-Ultra-Transfer-Speeds-s-SDCZ48-016G-UAM46/dp/B00KZIXSP6
Ethernet Cat6 cable: https://www.amazon.com/Mediabridge-Ethernet-Cable-Feet-31-299-10B/dp/B006JN6PL0