Nvidia CEO Jensen Huang's affair prompts a major stock drop, sparking both concern and opportunity as investors weigh risks and market fundamentals.