The SPAL electric fan was one of the best modifications I've made to my car. I built a double relay fan controller with a thermostatic switch. With an old school three row copper/brass radiator its had no problem keeping the car cool, even in weather where the heat index was over 100 (at that temperature I might add it only ran about 5 degrees hotter than at any other time). Its been on the car for two years and been 100% reliable. I did a round trip from my house to Atlantic City back in September and it functioned flawlessly over that 150 mile excursion.
I get the simplicity of mechanical fans, I truly do, but every new vehicle has an electric fan now, and has for close on to two decades. The reliability issues people may have had almost always stem from a cheap aftermarket electric fan. A high quality fan, sized appropriately will have no trouble keeping your car cool, and being perfectly reliable.
The big thing to be aware of with electric fans is there is no industry standard for how to measure fan flow. Most companies do not test the fan against restriction, and this is why you'll see cheap fans rated at 3,000cfm. Those numbers are pure BS, because the minute the fan has to operate against restriction the real numbers would be lucky to be half what they claim. Last I checked a radiator is a restriction, so if you actually plan to use the fan you need to know real world numbers. This led me to use the SPAL fan I did, because they realistically rate their fans. Another dead giveaway is that it takes about 10 amps to move 1,000cfm, so if you see a fan rated at 3,000cfm that only draws 15 amps in operation you can be sure that's BS too. My fan is rated a little shy of 3,000cfm, but draws over 30 amps at start up and mid 20s continuously, so I know its really moving the claimed air, even behind an actual radiator.
Fixed fans rob a fair amount of HP, and are also on all the time. I've found this results in over cooling in cold weather and the engine seemingly never wanting to get up to temperature. Perpetually running an engine too cool results in accelerated engine wear. This issue is why I went away from a fixed fan.
Flex fans claim to skirt the HP drain by flattening out at higher speed to reduce parasitic drag. IMO flex fans are ugly. They don't look like they belong on a classic car, more like leftover aftermarket stuff from the '80s. IMO they belong with over chromed out engine compartments and braided stainless hoses everywhere.
Clutch fans can eliminate the HP drain, except when in operation, but clutch fans add another component that can fail (I've had two clutches fail over the years), so the idea that its more simple and therefore more reliable isn't really accurate in my experience.