Our Sidepower stern thruster sheared a key where the main bevel gear is attached to the shaft that goes thru the transom to the elec. motor. The boat had to be removed from the water and the thruster gearbox completely disassembled to fix it. There was too much torque for the size of the key, and machining a bigger keyway was not an option. I consider this to be a design flaw. Either the shaft should be bigger, or there should be a spline.
Except for that, our Sidepower bow and stern thrusters have worked well. They are each powered by 2 8D AGM deep cycle batteries in series for 24V. (The rest of the boat is 12V) They are charged by a dedicated 24V charger, so the batteries get charged only when we are on shore power, or when the generator is running. We often use both thrusters at the same time, in the same direction to slide sideways, or in opposite directions to spin on the spot. We have never run out of battery power.
Although I have no experience with hydraulic thrusters, I often wonder how well they work, since the engine is always idling when the thrusters are needed. I once toured a boat where the thruster hydraulic pump was attached to the generator. This solved the low idle RPM problem, but the generator had to be running to use the thrusters.
Our previous boat (a 36ft trawler) had a 12V bow thruster run off the house batteries. That arrangement worked well too.