Very few shops can do what you're describing. It's not something that is often worthwhile enough to get budget and engineering time. If you're reaching into your backups for a full restore then you're going to have data unavailability due to the nature of how cold backups work. Having delayed replicas and warm backups are a godsend when you have them but lots of shops don't want to pay at least 2x for their production db cluster and know the tradeoffs they're making.