My experiences with raspberry pis has been exclusively and extremely negative.
The first one I owned had some kind of electrical fault that bricked and destroyed my TV.
The second one I owned had a fault where a few of the capacitors on the back fell off upon me plugging it in for the first time.
The third one I tried had a fault where it would spontaneously shut down if I had any USB devices plugged into it for any reason at all (in this case it was a mouse and a flash drive).
The fourth one I owned had the same problem, and the way I fixed it was desoldering its onboard wifi receiver running it at an absurd underclock and overvolting the USB2 input with my bench power supply.
With that said, let me talk about their hardware.
The USB-C implementation on the raspberry pi 4 violates the USB spec. When this was brought up to the engineers over there, they completely memory holed the problem, saying it works on USB2 chargers through an adapter. I call bullshit because during normal use it will draw more than 12.5 watts (which exceeds power limits on USB2 cables).
I have never seen the micro HDMI port on anything made before 2013 so the adapters required to make it work with modern TVs may as well be proprietary ones sold by RPi.
The camera input connector is encrypted for some reason, so if you wanted to use a camera through there it has to be one of raspberry pi's.
Despite them claiming it's opensource, it really isn't. The only thing that they have made opensource is the schematics which are largely useless for integrating into your own designs. The main processor onboard (and a handful of other ICs) isn't even commercially available. They claim it is, but that's only if you order it in minimum quantities of a few hundred thousand or something.
So in order to use the RPi4's most basic features, you need a proprietary charger, a proprietary camera, and a proprietary video output dongle. These things are more locked down than most laptops.
And that's just the problems with the RPi4. That has absolutely nothing to do with the litany of problems the past versions have had, which I don't feel like listing here. One of the issues that comes to mind is that the RPi 3 had a problem where it would spontaneously shut down if the lights in the room flickered wrong.
Worst of all, because these clowns have mindshare it means that other more well-behaved SBCs will never get any form of community tech support or large enough marketshare to make any notable change.