Although it seems logical that a powered hub should solve SuperDrive issues, Apple documentation says not to use hub but provides no further explanation.
Remember that the last upgrade to the USB SuperDrive was about 12 years ago. However, others seem to get the to work.
Some things re optical drives:
1—An optical drive will not appear on the desktop unless a valid disk in inserted. Neither will it appear in the Finder sidebar. From my older Macbook Pro with a very functional optical drive but no disk in it:
The drive, if getting power, WILL appear in System Information, with or without a disk inserted, under "USB" in the left-hand content pane.
2—Some have reported they had to use Apple-branded USB to USB-C adapters to get their SDs to work. Three specific adapters are listed in this Apple article:
How to connect the Apple USB SuperDrive - Apple Support
However, other say that they had success with non-Apple adapters.
3—Please do not think I am being insulting or flippant but I must ask this because it is the single greatest cause of SuperDrive issues: Is the silver side up?
If a power hub is going to help, I do not think brand is a huge issue. I've had decent performance from Sabrent brand powered hubs. I bought mine from OWC (macsales.com) but Amazon also carries that brand.