In most situations, of course, the automation is good, preventing pilot errors like stalling or exceeding safe control inputs, but these are fundamentals that every pilot learns in the first few hours of flight training. Unlike some fighters that are inherently unstable, a 737 can be flown safely without the computer overriding the pilot's control inputs so long as the pilot flies reasonably.
I've had a similar experience in a car. Antilock brakes are designed to override an erroneous control input: braking too hard for the available traction. In the event of a wheel speed sensor malfunction, they can override a reasonable control input: moderate braking well within the limits of the available traction. This is terrifying, and there's no way to override it in the moment. It can, however be overridden in most cars by pulling out the fuse for the ABS.