I am 95% against Nat 1 fumble rules. Every time we ever tried it, the game became ridiculous Keystone Cops-like. Player Characters make more rolls on screen than any other character. You know how often they are dropping their swords, or blasting their allies with all the Nat 1s they roll? Not very dignified or serious in the heroism.
While it is not usually my cup o' tea, I would consider it as an optional rule specifically for a comedy game where the heroes get a lot of opportunities to look incompetent, or if the players like to roll with the ridiculous. Like a Guardians of the Galaxy-style game where players mock each other for failing, as fumbles make them fail ridiculously as often as they critically succeed.
That said, I am ok with it as an option to opt into, but not a main core rule.