I'll add a couple of others too.
Fight Club. The title is awful and I expected it to be a film about fighting which is why I took so long to watch it. Now it's in my top three films ever. I've seen it about ten times. AWESOME!
Up. I wondered how a cartoon could be that good so never watched and turned it on by accident over christmas. Best love story intro ever and a really good film.