A lot of them do, most of my favorite ones can just pull me in no matter where in the movie I discover it, but the weirdest one has to be the Kennau Reeves, Gene Hackman movie about a cobbled together pro-football team during an NFL strike,
It's gotta be one of the silliest movies out there, the sports radio station I listen too just absolutely loathes it, and won't even call it a sports movie. But I just get sucked into the whole buddy movie concept of all the goofball characters they recruited, like the Sumo wrestler, the chainsmoking (on the field even) soccer player as kicker, the "ganstas" and the deaf player, and how they all come together to be a winning team.
And the stripper cheerleaders don't hurt either.
http://www.youtube.com/watch?v=yKYJRnckd_o
And the dance number.
http://www.youtube.com/watch?v=jpCZzycMhPk
I can turn it on anywhere, and end up totally drawn into it. Crap, I think I need to watch it now...