DataStore should offer interval delta polling as an alternative to real time subscriptions

[nubpro]

Is your feature request related to a problem? Please describe.
In our production use case, DataStore subscriptions are giving a handful of issues which aren't easily fixable from our end.
We would like to run the app on top of DataStore 24/7 with minimal downtime, however we would notice that subscriptions would somehow fail and aren't able to recover. Therefore, we are losing a lot of data and it kept us away from DataStore until it's fully robust and tried and tested in a real environment.
I have listed down a couple of the issues we faced on #6488 with subscriptions.

Describe the solution you'd like
Instead of relying on real time subscriptions through websocket, perhaps DataStore can offer an alternative way of pulling updates from the backend. Interval delta polling doesn't sound too bad, well at least I'm pretty sure it's much reliable than PubSub.

Describe alternatives you've considered
none

Additional context
We are actually in the midst of implementing our own method of doing delta polling over DataStore's subscriptions. Using elastic search and writing my own custom sync engine that would work alongside with DataStore existing feature such as the mutation processor, observables etc. All except subscription processor and sync processor.

[wei]

Somewhat related to #5037

[swyxio]

+1 from the Amplify livestream today