This is getting dangerously close to how some AAA MMORPGs handle[d] much of their logic and state management.

At the scales these games operate, enterprisey oracle clusters start to look like a pretty good solution if you don't already have some custom tech stack that perfectly solves the problem.