Hey, thank you very much for positive feedback!
Regarding your suggestion, yeah, this is a big point of discussion usually, where it either works completely fine, or completely screws you over. Everyone encounters at least one death spiral at least once, and that is by design, I really wanted everyone to get that "gotcha" moment where they see that the usual approach of clicking the + button doesn't work, but I think most of my negative reviews on google play come exactly from this mechanic lol. What I can tell you is that pretty much everyone stops having these moments at some point when they keep playing, or at least that's what I gathered from people who actively discuss with me on discord.
For now there are two things that can help you a bit, there's "Show Details" button, that shows your stockpile sizes, how much you produces vs consume and how fast your stockpile will run out, so that can help with planning. Second is the "Consumption" button, this should have the functionality you described, it shows separately how much resources are consumed by Research, Military and Production respectively, this should make it a bit more bearable I hope!