Very much depends on the model, trim level, and generation. Even on the Mazda 3, the location of the USB hub depends on whether the car has a CD player.
I did the "drill holes in the front of the USB hub" trick so I didn't have to remove the console. But then I dropped a socket and ended up having to remove the console to retrieve it and it only took maybe 15 minutes. I could do it again in 5 knowing all the steps.
Turned it into a 15 minute job vs probably an hour+ of messing with the center console. Babysitting the software update takes the most time.