In what scenarios would you choose DBaaS over a self-managed database solution?

For those of you with experience in both DBaaS and self-managed database setups, when do you decide to go with a DBaaS solution? I’ve heard DBaaS is great for startups and small teams, but are there any specific scenarios (like scalability or maintenance concerns) where it really shines? What trade-offs do you consider in terms of cost, control, and flexibility?