All the interviews, etc. indicate Super Ball was retired because it took up too much time for the reactions it was getting. Which IMO was a self-fulfilling prophecy, because the prizes they put in the game rapidly declined by the '90s. The earlier playings were more in line with what I think the game needed - a prize in every door worthy of being played for on its own (hot tubs, trips, etc.) [...] The first playing I drummed up on YouTube from '96 had small appliances (microwave/mini-fridge/bread maker), a dining room and a gazebo behind the doors.
Even in that example, though, two of the three doors
did contain a prize that would normally be used as the featured prize in Grocery Game, Cliff Hangers, etc. -- the problem in that case was that even though it was an expensive gazebo, nobody in 1996 cared about winning a gazebo.
What has struck me about seeing Super Ball in the season 11 episodes is that the total value of all three doors was often the same as or better than a showcase. In that 1996 example, however, the total value was $7,954, and I suspect that showcases were always more than $10,000 by that time. Which goes back to your point about all three doors needing to be valuable.
But yeah, short of it becoming a dedicated car game (and even that would have its problems -- "You won the car! Now try to win the super ball to pick up the two prizes you don't care about!"), Super Ball was eating up too much time for the fun it was capable of putting out. And I know some people here really love skee-ball, but watching somebody else play skee-ball four times isn't that compelling, in my opinion. Hole in One would be a slog if it were "Hole in One or Two or Three or Four."