More often than not they are a bad idea.
Because often you are required e.g. by the courts or legislation to truly delete something.
Trust isn't an issue; a conventional database will be perfectly fine. Like, if you wanted to sell a product for tracking vaccines (assuming, for a moment, that health services and other large vaccine buyers don't have decades-old systems for this which everyone already knows how to use, which, if course, they do) why would you bring The Almighty Blockchain into it?
> If it had been logged to a DLT with an immutable ledger
.. while the power was off?
The vaccination rate is about a million an hour: https://ourworldindata.org/covid-vaccinations (!!), no blockchain is going to keep up with that.