alt Hacker NewsOverrated surely? It's a pretty bog standard MCU, no wireless support, mediocre deep sleep. I don't know why you'd pick it over an ESP32 or nRF5x.
The only standout feature is PIO which is definitely interesting but very niche. It's also patented so say goodbye to any portability or FOSS vibes. (If you want a FOSS version btw, check out https://baochip.com/)
If it didn't have the Raspberry name behind it nobody would even have heard of it.
The PIO are pretty great and not niche. Almost any embedded application needs mixed signal interfaces. You could say embedded applications are niche, but not that embedded applications needing mixed signal interfaces.
A serious warning: read the RP2350 errata carefully. You may be better off buying old 2040 inventory.