The question is not one of how much horsepower but one of how much torque does the engine produce.
Without AWD you will not be able to ground all the available torque the typical 300 HP engine can produce. You will spin tires before you shear the lugs or studs. Tire tractive force is your first “fuse”. Spinning tires keep other things from breaking. So you may say, let’s just use stickier tires like race rubber and a LSD to help reduce wheel spin (it will still occur).
Wheel hubs still won’t be the limiting factor.
CV joints will be a limitation before hubs. Axles / transmission / transmission output flanges will typically break before the hubs.
After you “upgrade” those weak links, eventually, the rear rear suspension consoles will begin to fatigue and will tear off the chassis.
See where this is going? Each “upgrade” just replaces one “fuse” with another. Each subsequent failure just keeps getting more expensive to fix.
Have fun!