I own and would recommend the Heil but, as was said before, it's a complex set up and you must have a head amp and separate cab as well as a PA (mic + amp) to run it.

As for the first vid sounding naff, a lot has to do with the way you use it. The Heil can sound like that too but if you practice articulating the sound properly, it sounds infinitely better. I find that taking the sound and shaping it at the back of your throat produces the classic Sambora-esque talkbox tone as opposed to the hollow, weak-sounding effect that comes from shaping the sound at the front of the mouth.

edit:

An example of the Heil used for LOAP in our tribute band:

http://www.bad-name.com/av.html (click on the audio demo and it's the first track)