Honestly; most people use a straight cut or dissolve.
Sometimes Pixelan SpiceMaster in addition to the standard cross disolve. Nothing else apart from AE in the transition area. KISS is my motto. If you are looking for all kinds of cheesy transitions, have a look at Magix, Pinnacle and similar consumer oriented applications.
For 99% of my work, it's Cross-dissolve and Dip-to-Black. For the majority of the rest, it's a Keyframed Levels, or Gaussian Blur.
I've already used my "Page Curl" Transition once, so cannot use it again. [inside joke]
I have ProDAD's Adorage and VitaScene, plus a bunch of Hollywood FX Transitions from an old copy of Pinnacle Studio. I do not think I have used any of these for Transitions.
Are there any types of Transitions that you are interested in?
Thanks for mentioning Pixelan. Yes, I have used SpiceMaster, though sparingly. I mainily use it to build Effects, more than pure Transitions. Good group of folk there too!
I have to chime in with Curt on this one. 95% of mine are cuts, with 4% dissolves and the other 1% miscellaneous transitions already included.
The transition effects that come with premiere cs4 seem boring.
They are supposed to be. A transition that draws attention to itself is no longer a transition, it's a special effect. A distracting one.