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.