It's an impossible question to answer.
PS3 games were getting to this level of spend, $50 million to $100 million, a long time ago:
The game sold "only" 4 million copies and that "wasn't enough," developer says.
www.gamespot.com
As good as Dead Space 2 was, it came out in 2011 and it would cost a lot more to make a comparable game with modern production values. Clearly though this market cannot function when games cost $250-$350 million and take 5+ years to make. I doubt Spiderman 2, for example, did that well considering Insomniac moved on as quickly as possible. It seems like Sony is trying to rein in costs.
But we also went through a "pandemic" where it seemed most game development just stopped for 2 years whle the costs kept incurring. And massive inflation that led to costs going up 20% immediately. So I don't know if some of the eye popping figures we have seen lately are representative or just part of short term challenges taht the entire industry and really the entire world went through. Ask again in five years.