I've been running 3 Primes for years—started with 1 3 years ago, and then added 2 more a year later, one of which was a refurbished unit. In all this time I've never had a problem with the devices themselves.
That's not to say there haven't been problems. I've replaced the CableCARDs at least once, and the tuning adapters a couple of times. Also, I was affected by the Prime ethernet firmware bug from a couple years ago that forced me to keep my Primes on a link local–only 169.254.0.0/16 network. (That encounter revealed how hit-or-miss SD's support is, having support emails ignored for months at a time with no communication.)
So, while SD's software leaves MUCH to be desired, their support is lackluster, and their forum moderators can act like totalitarian dictators when discussing complaints or competition, their hardware is usually—almost always—rock solid. It's also unfortunate that they are pretty much the only game in town for network–connected tuners.