And for the vast majority of cases the chip is fine, I2C is fine, the ADC is fine (despite what hackaday says), the SPI is fine, GPIO output is fine, GPIO input-with-pull-up is fine, GPIO input-with-pull-down needs a stronger pull than usual, 4K7 works great.
The use-cases where you have problems are being blown way out of proportion IMHO. All chips have errata, there are workarounds to most of this one’s issues, and there are alternate solutions for the few cases where it can’t be worked around. This is normal.
I’d also point out that there’s a guy on the RPi pico forum who’s successfully linked a touch-sensor input to the RP2350 without problems…
Bigger picture, RPi is doing their third ever chip fab. The errata (silicon bug) list for the prior RP2040 is shorter than some I've seen from companies five times their age.[1] This issue isn't a logic error and wasn't going to be found by digital simulation. This is analog weirdness. Their documentation, including of errata, is among the best I (moderately experienced hobbyist) have ever encountered for a microcontroller. RPi is doing an excellent job and this is a but a hiccup. Maybe it's concerning for industrial customers, but as a hobbyist I'm still excited for my Pico 2 to arrive.
[1] Favorite errata warstory: Radio chip will lock up and need to be power cycled if a received packet has a particular corrupt length field, one bit flip away from one we used. Official solution: don't allow packet corruption. Turns out radios don't work like that.
Input on a pin tied to gate happens all the time.