I am in need of tricks that are straight out, will get a "oh-my-god" and that can be done on the spot.
Any trick can recieve a "oh my god" response, but once again it comes back to presentation. With your TT try something different, Vanish some water, sand or perform a bill switch. If your presentation is good any of those can get a "oh my god".
With your "pen through paper" i'm assuming you've got the B2 bomber/stealth pen, if so stab it right through someone's $50 note. Once again it boils down to presentation, I've recieved "oh my gods" from presenting it as a "torn and restored" effect.
Presentation is key.
As for products that I reccomend,
can be done on the spot
Gregory Wislon's on the spot. Ordinary items. Extrordinary magic.
If your not using the Stealth pen/B2 Bomber "method" i would also
reccomend one of those.
If you're after an Invisible thread trick.
But just search the forums there are plenty of topics like this one.