> People using them as cheap computers ruined it.

IMO it is the people using them as embedded controllers for their products that ruined it, in combination with the poor decision by the Raspberry Pi folks to prioritize commercial demand for the products over hobbyist demand during the pandemic. We hobbyists "made do" with other solutions in that time, and now there's no real need to go back.