I've had the same experience with non Raspberry Pi boards. They've become useless thanks to endlessly broken software and zero support. My rpi's have been useful for years and are still getting regular updates.
I think I too was drawn in by the performance claims made by those other manufacturers. I realized though that raspberry pi are very powerful computers. We just take the scale of modern computing for granted and our software is the real problem.