I want to better understand the reasoning behind the "scale to zero" point that many people mention.

only case I could think of is that businesses that want "scale to zero" have very low total expenditure on the database. is this the case for you as well?

because serverless without going to zero still solves a major problem for a lot of companies with some decent scale, where there is some decent traffic and its too hard to implement database autoscaling and most businesses have unequal traffic (daytime and nighttime etc,...)