> I can understand that scaling out the game "work" into multiple CPUs and dedicated processors makes sense from a cost-benefit perspective

IIRC it was not that, the Saturn was the most expensive to manufacture of the big three, and the need to price match the PS made it a financial disaster for Sega.