While the Hole in One shot may be the most difficult to hit because of the randomness of the ball being out of contact with anything, the hardest shot to a traditional ramp or entry for me is the Guile shot on Streetfighter 2, long, tight and crucial.
If you are talking the most tension filled shot, then that is making the ramp to Melt the Witch on WOZ, nothing else quite like it!