I had a PS3 die on me, but I think that's about it. I had a 360 that I sold to my brother and it apparently died like a week later.

Now there are consoles I thought were dead that ended up not being dead. My NES hadn't worked in years, but I took it apart and cleaned the connector pin things inside and put it back together, and it's worked okay since. Not perfectly, but I haven't had too many issues.