Tragedy and criminal activity are as much a part of the Real Housewives franchise as designer handbags and multimillion-dollar mansions.