The 737 Max 8 is different because the MCAS system actually overrides the pilot's input, rather than just sounding a warning to alert the pilot to a potentially dangerous situation.
In normal operation it takes the input from the pilot and decides how to accomplish what it thinks the pilot wants. For example, if the pilot pulls all the way back the plane will translate that into the maximum safe climb rate. You can think of it as the pilot expressing a desired state and the plane figuring out how to get there.
>In an emergency, if the avionics computer goes crazy and starts making the plane do barrel rolls, can the pilot override it and take manual control?
AFAIK there's no way to disable the flight control. The computer is supposed to be reliable enough to not do crazy stuff and it accounts for sensor errors. Based on what sensors are malfunctioning different safety features are disabled. For example, if it can't get a reliable angle of attack reading the stall prevention is disabled.
As far as I know, if the autopilot can't make reliable decisions, it rings alarm bells and disengages fly-by-wire. Looks to me like quite elegant design.
I thought the boeing plane only needed the system because their engines were positioned so far forward, and that the airbus plane didn't have that problem, so shouldn't airbus not need the stall system?