ive only used cloudformation, but things like deletion protection, and the hug of death are quite nice to have for making things feel safer.

at least with my organization of a separate stack for {network, data, and compute}

cloudformation would refuse to just delete the data base until you first tore down the api that uses it, and while that would still make an outage, you dont lose data before knowing something is wrong.