This is the OTG adapter I use. https://smile.amazon.com/gp/product/B083WML1XB/

I think they are all somewhat flimsy. I velcroed mine to my NES Mini so that moving the unit wouldn't put any stress on the cable.

You don’t need the adapter AND the hub, you can just plug in a powered hub in between the microUSB cable and the port on the console, like https://smile.amazon.com/AuviPal-Adapter-Playstation-Classic-Raspberry/dp/B083WML1XB

(There’s an option for the 2 pack of the same hub on your link)