Myers' focus on family, personal struggles, and commitment to unique projects have led to a decline in commercial viability. For two decades, Mike Myers had the Midas touch.