Nvidia CEO Jensen Huang resigned after admitting to an affair with a woman accused of being a Chinese spy, amid further allegations of relationships with subordinates. His downfall adds him to a list of flawed Silicon Valley billionaires like Jeff Bezos and Bill Gates.