June 2008 was the month that SNL's two biggest movie stars saw the blockbuster rug get pulled out from under them.
Zohan opened on June 6 in the US and limped to just over $100m domestic on a $90m budget. He had been on on a box office heater before that - Anger Management, 50 First Dates, The Longest Yard, Click, and I Now Pronounce You Chuck and Larry all making way over their budgets.
After Zohan, he had one more live-action box office hit with Grown-ups, which was very bland, in 2010 ($162m) but only made $103 million with the Anniston star power in Just Go With It, and then went spiraling into Jack and Jill and That's My Boy, before realizing he could make a spit ton of money being a wacky Count Dracula voice.. Sandler has continued hitting the low-hanging fruit though and doing what he wants to. The same can not be said for Mike Myers.
Two weeks after Zohan, Mike Myers' "The Love Guru" opened and bombed hard, making $40m domestic on a $62m budget. Myers had been on a 16-year run of blockbusters, on a nearly 10-year run of blockbuster success.
Austin powers 2 made $206 million and Goldmember made $213 million. Shrek 1 made $268m, the second made $439m, and the third made $322m.
Then Love Guru came and other than Shrek 4 2 years later, the only major movies he's been in have been stunt casting in Inglorious Basterds and Bohemian Rhapsody. Shrek 5 is in production now.
As those two fell, the guy from the next generation of SNL was at the top of his game. Although he had a few misses, Ferrell still had a 5-year run from 03-08 of Elf, Old School, Anchorman, Wedding Crashers (extended cameo), Talladega Nights, Blades of Glory, and Step Brothers.