iphoto versus imovie - wanting to get features from both places
Versions of iMovie after iMovie HD don't support plugins and extra effects.

You're looking for something more along the lines of Apple Final Cut Express ($170) or Adobe Premiere Elements ($80).

Both let you make photo slideshows with titles, effects, transitions, and music; and both let you install free and paid plugins for more.

Hope this helps.