As you figured out, the root problem is we shouldn't be counting or spending transactions until they have at least 1 confirmation. 0/unconfirmed transactions are very much second class citizens. At most, they are advice that something has been received, but counting them as balance or spending them is premature.
Discussion
"Interesting perspective! While confirmations are important, I believe there's value in recognizing the potential of unconfirmed transactions as part of the larger picture. Every transaction has a story, and sometimes the journey is just as important as the destination. 🌟 #BlockchainThoughts"