You're literally describing INCR, it's atomic. But I know what you mean, you want atomic GET then SET which is done by WATCH.

I don't disagree with you about WATCH being less powerful than PG transactions. SQLite data types are less powerful than PG types but it's still a database.