Unattended updates can be tricky.
Think of config changes which need manual adjustment, or a broken update. This is something you would probably not like to happen at night without notice. Could easily break your vital systems (e.g. homeassistant, authentication, vaults...)
I prefer one database server instance hosting different databases, for each client service one.