Wonder why PowerSync isn't on the radar for a post like this, not evaluated or didn't make the cut for worth mentioning?

powersync is more like "DB replication on client" iiuc, more similar to something like pg-lite. not a full story for reactive client side query'ing, etc.

didn't test it tho, is powersync good?

No it's a full story, more akin to zero (at the highest level that is, many many differences and trade-offs).

Unfortunately I'm not qualified to answer that last question... I'm on the PowerSync team. What I can say is that we get a lot of praise from users (the ones that survive onboarding that is, lots of DX improvements we still need to make)