In no way is it "stupid proof". First of all, there are many factors you have to consider. You have to choose the right recipes wich means the right powder for a particular bullet style, weight, overall length of cartrdige etc...
If you have the right powder, the correct charge, the correct bullet weight and primer for that recipe, you can seat the bullet too deep and be in serious trouble with pressures.
If you use a powder in a 44 magnum designed to be used for a 9mm, you could be in serious trouble. You have to have a good reloading manual and follow the recipes starting at a reduced load working up to what shoots best in your gun while watching for signs of high pressures. If you are pushing the high end of the pressure range and happen to load 1/2 a grain too much powder then you could have a kaboom.
Reloading is safe and fun and can bring out the true potential of your firearms but only when done properly. A $600.00 reloader will not be "idiot proof" if the guy behind the press doesnt know how to set it up and keep an eye on things. Even running out of primers and settling for another brand becuase they are out of your favorite, can lead to increased pressures.
I have a Dillon press that can produce 600 rounds an hour and I still measure my overall cartridge length about every 50 rounds to make sure nothing has changed, I also weigh the first 5 pounder charges every time I start a new batch of ammo.