>Pi 4 has 2 HDMI outputs!
Two full-sized HDMI ports could fit on the board. At least, I could fit them. I question the competency of all the engineers working there.
>Most likely your power adaptor would not be able to maintain stable voltage when your lights flickered.
No. It was due to the wifi/bluetooth tranceiver not being potted and it would hard-reset if disturbed too much by the photoelectric effect.
>Anyway, have been running ...
Anecdotal evidence. They are built like absolute trash and it's a miracle anybody says they work for any reason.
> more well-behaved SBCs
Wake me up when someone makes one with ECC ram. I will not entertain using one unless it does.
They are made from the floor sweepings in Sony's factory.
You don't hear about the failures because most people just buy them and throw them away. I would venture to guess that about 60% of their customers are one-time buyers that try to power it on once and throw it away because it doesn't work. The other 40% either won the lottery or put up with its constant stream of shit because they have a near monopoly. The same is true for 3d printers.
Out of at least a dozen people I know using them, every single person has multiple RPis that has been in pretty regular use. On top of that you have a plethora of documented uses and projects across the internet, ranging from home automation to arcade machines.
You seem to be painting an entire community with the same brush, but most of the people in this community would gladly help you solve the issues you seem to be facing. Perhaps the issue lies not with the RPis but with how you're using them....
In reality, fully working raspberry pi boards are normal. I must have at least 10. I admit I no longer use the original model (so slow) but last time I tried it worked just fine. I think that's pretty great for the money, especially considering the state of the market before they came along which I think you might be forgetting.
I have a power supply that is so weak that Pi would reboot when I plug a USB keyboard in it. Solution: never use weak power supplies on Pi's.
> 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.
Pi Zero uses mini HDMI due to size constraints. Pi 4 has 2 HDMI outputs! Instead of adapters, I always prefer "right" cables. More expensive but convenient. E.g. https://www.amazon.de/Snowkids-zukunftssicheres-TV-Kabel-unt.... Also, ironically, my 2012/2013 ASUS Zenbook has a microHDMI port.
> 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.
Have you tried 2-3A power supplies? E.g. https://www.amazon.de/Anker-PowerPort-Wandladeger%C3%A4t-kom.... Though I found the "official" supply cheaper and went with it.
> 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.
Most likely your power adaptor would not be able to maintain stable voltage when your lights flickered.
Anyway, have been running 3B+, a few Pi0s for a few years and this is the first time I read about so many problems with Pi's falling on one head. To keep my SD cards alive longer, I use DietPi and had only one SD card die on me over ca. 10 pi-years of uptime.
> more well-behaved SBCs
I am all ears!