I think there might be a difference here for using modals in a website and in an application.
Modals in a website rarely have a place. Modals in an application can be very useful if you have an isolated task that needs input or if you want to clearly communicate whether or not a particular state has been updated.
I don't really understand the problem with "stacked" modals though.