Just to clarify, the term "USB controlled" as you use it means a Controller that has a connection cable to a mobo USB2 header, allowing it to communicate with some software utility running under Windows. That software takes over control of fans connected to this Controller. MANY such units do NOT have any way to input the info from a mobo fan header, so you do NOT usually have the option to let the mobo's fan control system take over control. That may be what you want - I don't know. Doing it this way does give YOU control of the fans - perhaps just manual control as your older Controller did, or perhaps some form of automatic temperature-based control, depends on what the software is designed to do.
Note that the Aquacomputer OCTO unit has only 3-pin outputs - it uses Voltage Control Mode only - so it IS suitable for your first choice of the Bgears fan. And since it can output 2 A per port, you do NOT need a Hub to get that power.
I will comment that the Corsair Commander Pro does not provide one piece of info - you might get this by contacting their Tech Support people. It does not tell us whether its output ports use the older 3-pin voltage control Mode, or the newer 4-pin PWM Mode. The fact that the ports have 4 pins tells us nothing. It MAY use only the 3-pin Mode which CAN control the speed of either fan type, but does NOT provide any PWM signal that a HUB might require. Alternatively, it may operate only in 4-pin PWM Mode and provide that signal, but then it could NOT control the speed of any 3-pin fan. Some device makers say "supports 3-pin and 4-pin fans", when then mean that a 3-pin fan WILL work, just at constant full speed. Third alternative: the Commander Pro MAY be able to be used in either Mode, with that choice being made by the user in the iCUE software tool. None of that detail is apparent on their web pages.
You have not been using mobo fan control in the past, so in case you're not fully familiar with that, here's a brief bit concentrating on CASE ventilation fans, and ignoring the CPU cooler for now. The CHA_FAN or SYS_FAN headers on a mobo are really TEMPERATURE control systems. There is a temperature sensor built into the mobo (in some mobos, additional ones for particular components) with a target temperature for that sensor. The default automatic control will constantly adjust the speed setting for the header's fan to whatever it takes to hold that temperature at the sensor - it really does NOT care what the speed is, and does not even need to know the speed. Usually you have three other options for each header. One is to fix the fan at full speed all the time, one is to fix it at a reduced speed for lower noise and reduced cooling, and one it to allow you to specify your own version of the fan "curve" of what speed to run the fan versus measured sensor temperature. SOME mobos offer a choice to fix the fan speed at a particular speed you can set manually, similar to what a third-party Fan Controller (such as your old one) did. HOW the speed is decided is the Fan Profile, and it is separate from HOW the decision is implemented by the MODE setting for that header. The header can output signals as a Voltage on Pin #2 (that is Called Voltage Control Mode) for 3-pin older fans, or as a PWM signal on Pin #4 for the newer PWM-type 4-pin fans.
A mobo fan header also has a secondary function. It monitors the speed signal sent back to it from the fan on Pin #3. If it gets NO signal (or, in some mobos, a speed less than a minimum setting) it puts up an alarm on your screen so you know the fan has FAILED and will need attention soon.
IF you would like to let the headers on your mobo control the speed of your case fans as they are designed to do, (AND assuming that they CAN use the new 4-pin PWM Mode), then you can use a HUB as I outlined earlier (that Gelid cable "arms" item) with a 4-pin PWM-type fan like the 1st Player one you linked to. The Hub unit will get fan power from the PSU via Molex, and the PWM control signal from a mobo header. But you cannot use a 3-pin fan like the Bgears unit with a Hub like that.
IF you want to control the fan yourself as you are used to, but using a software interface rather than a front panel then the Aquacomputer OCTO unit probably will do that job. It works best with 3-pin fans like the Bgears, so don't bother with a 4-pin fan for that Controller.