I have a SGZC12RC from several years ago (maybe 2014?) with Lexar 64GB memory card bought at the same time and both have been flawless for many tens of thousands of miles.
Also a Panorama of similar vintage which has never given any trouble.
Both still record good images. Good enough to remain in use for a few more years yet.
In fact, what brought me here was to check out recent discussions of Street Guardian cams because with numerous ageing cams in our household's cars, and with two of our cars being damaged in non-fault accidents during the Christmas period (in both cases the other driver was young; late-teens or early-twenties), so it's probably about time to think about a new cam in a couple of them.
I also have at least two of: Mobius, JooVuu, Cobra 840, Mio 5-series, Transcend DP100, Blacksys cameras.
The capacitor-equipped ones have been more reliable than the battery-equipped ones although the Mobius with capacitor doesn't suit the electrical system of some of our household's cars.
Many people had trouble with the JooVuu cameras but mine still work fine; they seem to be a bit fussier about power supply (need more like 1.5-2A power lead instead of common 1A) and memory card (need a card that can maintain good steady write speed for prolonged periods, which isn't necessarily those cards which score best in published speed tests - Samsung and Transcend do well, Kingston, PNY and some others don't).
The biggest source of problems I've had is memory card failure, affecting many brands of card. Second biggest problem is the 12v-to-5v power supply failing rather than dashcam failing. Dodgy power supply then causes a cam to behave erratically, or can even kill the cam's battery because it can't charge properly.
For me, Nextbase cams have given a lot of trouble, unreliability and generally short-lived (especially for the price) so I probably wouldn't use one even if someone gave me one.