That one is only kinda funny if you sing with the theme song tune.
I have a little story about this particular title, and I think it's kinda funny. I was walking in Wal-Mart a year or so ago, I guess, and anyway, I was going through the produce department. There was an older man stocking the tomatos and one of them fell off of the display and rolled right in front of me. Well, I quietly "sang" the title of the movie ("Attaaaack of the Killer Tomaaatooos"), and then, I noticed the man was laughing. He had heard me, and I really didn't intend for him to. Anyway, I handed him the tomato, and it was all over and done. The End!
Funny titles: I can't really think of one, but sorry I birdwalked.