Definitely YES, there IS a power limit. All such systems supply power at 5 VDC to connected devices to use. For the older USB2 system, the limit is 0.5 A total load per USB host port. For the newer USB3 systems (now all called USB 3.2 Gen
n) the limit is 0.9 A. So if you are using a small Hub to connect several devices to one host port, that's the limit. Many devices like mice, keyboard, and a few others use very little power. But others use nearly the max. A good example is portable "Laptop Hard Drives". ALL such drive units use MORE that the 0.5 A limit for USB2 ports. Older drives designed for USB 2 use came one of two ways. Some had their own "wall wart" power supply modules you have to plug in. Others came with an odd cable with TWO USB 2 connectors on one end, and you had to plug BOTH of those into separate host ports to get enough power to run the drive. NOW the new drives for USB 3.2 come only with one normal USB 3 Type A cable and CAN operate within the 0.9 A limit of the host port. But that uses ALL the port power limit and you generally can NOT plug an additional device into that port. NOTE that such USB3 Laptop Drives SAY they are "USB2 compatible", but that means ONLY that they CAN communicate with a USB2 port (at the slower speed) IF you somehow arrange to provide them with the extra power that you can NOT get from that USB2 port.
Here's a typical symptom of inadequate power when using portable hard drives on a USB2 port. The drive unit DOES appear in Windows Explorer because it CAN "talk back" when addressed. BUT when you actually ask for data to be obtained from the drive, it locks up and fails to deliver because the major electrical load is from the motor that drives the spinning disks. That load is more than the 0.5 A available from a USB2 port.
How to "get around" this limit? Use a HUB that has its own power supply module provided. Such a system provides power to each of its output ports from the module, but then can communicate with the host port normally (noting that the total data transfer rate of that port is shared among all the devices on the Hub).
BEWARE of Hubs described as "bus powered". This means they get ALL their power from the host port and have NO additional power supply module. This is the simplest Hub type that IS limited to the 0.9 A max load.
For a simple Hub used only for data, the power supply module included needs to provide enough power for all its ports. In older USB2 systems that's 0.5 A per port. But today you are likely to find only USB 3.2 Hubs, and you can plug any USB2 device into its ports anyway. So ideally with a USB 3.2 Hub your power module should able able to provide 0.9 A PER OUTPUT PORT. However, it is NOT common for the module included to meet that target. That is because the designers (correctly) assume that you will NOT be actually USING all the ports simultaneously, even if all those ports have devices connected. Thus it is likely OK to have a power supply module able to provide about 60% to 70% of the theoretical max - for example, a Hub with 7 ports might be OK with a power module able to provide 4.0 to 4.5 A total.
But here is where it gets a little complicated. Those power numbers are for 5 VDC at the specified Amps. A LOT of such Hubs come with power supply modules that provide power to the Hub at 12 VDC, and the Hub converts that to 5 VDC with a small power capacity loss. So IF you have that type of power supply module included, you have to calculate, based on the fact that power in WATTS is Voltage x Current. So you get module output at 12 Volts and
n Amps (or in Watts already stated), and you have to calculate how many AMPS that comes to when it is converted to 5 VDC for the Hub's output ports. Do this as port amps (at 5 VDC) = Supply WATTS (= Supply Volts x Supply amps) /5. For example, a module that can supply 35 WATTS at 12 VDC can provide to the Hub 35 /5 = 7 AMPS. That is more than enough for 7 output ports at full use, maybe 10 ports allowing for the "sharing" factor of non-simultaneous use.
An alternative calculation method IF you have a power supply module at 12 VDC to the Hub, is to do it all in WATTS. Each data port should require up to 5V x 0.9 A = 4.5 WATTS. So for example a 10-data-port Hub might need 45 WATTS from its power module, maybe derated to 32 WATTS for non-simultaneous use. (That would be 3.75 A at 12 VDC for full load, or 2.67 A derated.)
MORE to consider. MANY powered Hubs now come with "Charging" ports. These ports can provide much more power than the basic 0.9 A per port of USB 3.2 systems for use with devices that can use more power for charging, OR are NOT even data devices and just need charging only. Normally such ports are labelled for their higher max current rating. So remove those from the calculations first, and base your initial calculations on the standard USB 3 data ports only. THEN go back and calculate how much additional AMPS will be needed from the power supply module to satisfy the extra power capacity of the charging ports. ADD that onto the data-only requirement to see how much the total max load is on the supplied power module. Is it still big enough?
An example calculation for a Hub with "dedicated charging ports" (i.e., ports that charge only and do NOT deal with data transfer) in addition to data ports. This unit
has 10 ports in total: 7 for data transfer use at USB 3.2 speeds, and 3 for charging use only. Among the data ports, three are rated as "USB 3.1", which now are called USB 3.2 Gen2 able to transfer data up to 10 Gb/s. Of these, two are Type C ports and one Type A. Four are type A ports labelled as "USB3", now called USB 3.2 Gen1 able to move data up to 5 Gb/s. Three type A ports are Charging only labelled as 5 VDC up to 2.4 A max load. It comes with a power supply module rated at 12 VDC output up to 5A.
Now the calculations. The seven data ports require max 0.9 A at 5 VDC each, max total 4.5 W x 7 = 31.5 Watts. The power module can supply up to 12 x 5 = 60 Watts. No problem supplying the data ports. But now add the needs of the dedicated Charging Ports. They each say they can output 5 x 2.4 = 12 Watts, and there are three of them - total load for these is 36 Watts max. That is a total max load of 66.5 W, more than the power supply module's capacity. HOWEVER, allowing for the NON-simultaneous use factor, that capacity certainly IS sufficient for this Hub to do all it needs.
I will note that I have seen similar Hubs with that kind of port count but with a power supply module of only 36 Watts, NOT sufficient for such a unit.
Last item. The length of the USB cable generally does not limit the power reaching the device. BUT it DOES impact the data transfer rate, and a very long cable may cause errors in data and thus a failure for that reason, NOT because of inadequate power.