Without knowing the "major limitations and bugs" it is difficult to recommend alternatives that avoid those same issues. Without knowing what the domain is, wh

Without knowing the "major limitations and bugs" it is difficult to recommend alternatives that avoid those same issues. Without knowing what the domain is, what the events look like, etc: it's very hard to suggest solutions to the problem (because we don't know the problem) Frankly it sounds like you need to partner with a software architect. Maybe Azure solutions engineers can help.