The difference is tone. The vomit scene is hilarious because it's treated like such a dramatic turn for the hero, when it's really just him puking a lot, then it's perfectly timed when you think he's done but he isn't, so the dramatic music continues.
The puppet jizzing relies way too much on everyone knowing it's weird. Everything pauses just so we can see him jizzing a lot and everyone being weirded out. Not to mention you have tonwillingly go out of your way for that sequence, whereas the vomit scene fits so perfectly into the bar scene.