I used to be a Hogan fan, but I got sick of his bullshit about 10 years ago when he had that feud with Shawn Michaels. They were supposed to have a long feud that went with Hogan winning a match, then Michaels winning a match, and then a rubber match where it ended in a draw or Hogan won. Hogan decided he didn't want to do the job though, he just wanted to beat HBK and be done with the feud, even though he was frickin' 60 and not wrestling full time. His whole run in the mid 2000s was really about promoting his show "Hogan Knows Best." HBK did the job as he agreed to, but he over sold on moves and basically made Hogan look like the douche that he was, it was fantastic and hilarious. That whole feud was pretty good actually, loved the Larry King spoof that HBK did.
<iframe frameborder="0" width="480" height="270" src="//www.dailymotion.com/embed/video/x2ebi9v" allowfullscreen></iframe><br /><a href="http://www.dailymotion.com/video/x2ebi9v_hulk-hogan-vs-shawn-michaels-wwe-summerslam-2005_sport" target="_blank">Hulk Hogan vs. Shawn Michaels- WWE SummerSlam 2005</a> <i>by <a href="http://www.dailymotion.com/imsoalone2009" target="_blank">imsoalone2009</a></i>
That said, I don't think the Leg Drop is necessarily the greatest finisher of all time, but I don't think it's as bad as people think. If a 300+ man dropped his leg on your chin/neck, you'd feel it. The move has a great setup too with the whole pandering to the crowd prior to the drop. I think the move has lost some of it's luster as finishers have evolved though.
As far as worst finishers imo, I've never been a fan of Bradshaw's Clothesline from Hell. Kind of cool when he gets an athletic guy that can do the flip as he's getting hit, but most wrestlers can't pull it off. Not a fan of the STFU/STF or arm bar submissions as a finsiher. It's certainly effective, but not an impressive finish unless it's countered into. In fact, in general I'm not a fan of submissions as finishers, with some exceptions like Rowdy Roddy Piper or the Million Dollar Man pulling out a Sleeper, or Jerhicho's Lion Tamer, or it's the Flair Figure Four Leglock, or Bret's Sharpshooter. All the wrestlers that used those moves as their main finishers built them up well and got the moves over, they made them work. Not a fan of Angle's Ankle Lock though, prefer that he uses the Angle Slam. Speaking of Cena and the STF, his Attitude Adjustment/FU sucks. The only time it's been impressive is if he's lifting the Big Slow. Not a Spear fan either, it's just been so overused by every wrestler that it really shouldn't qualify as a Finisher.