A good VPS on a good platform is highly unlikely to have any problems and especially not between upgrades.
In nearly 8 years of running one of my forums I’ve not had a single loss of data.
the daily batch is designed as a trade off for most self hosters.
it’s a simple-ish system, regime and doesn’t demand too much space and processing.
I cannot imagine it being worth to do more often for most people.
I have never needed to use a back-up for online crashes, only use them for migration to new servers, if when necessary (because I’ve outgrown the smaller one!)
YMMV
However, if you do think you need a more frequent set up … be ready to customize your setup and be prepared to maintain that customisation (which would involve learning how to do it and/or hiring someone to help you)