I am wondering if anyone can recommend a program that does those cool photo slideshows I see out there. The one's with many various animations, backgrounds, effects, etc. I'd like the software to be as auto as possible, so I can set up the template, not a lot of time spent.

I know many people use After Effects, but don't wanna learn that. I use Premiere on PC, so would like to export this slideshow from the software and be able to import into Premiere to add music, combine with other videos, etc. in the Premiere timeline.

Thanks.

With ProShow Gold or ProShow Producer by the Photodex company you can do that. You do not need to import it afterwards to add music. This is also possible with these programs, as well as adding text.

Correct me if I'm wrong. But I think you can also add video clips to with ProShow.

You are right, you can do that as well. It is a very sophisticated tool.
You can see an example here:
A part of a video can be seen at 11:15.
Slideshow Forbidden Valley's on Vimeo

Thanks - The ProShow Gold is exactly what I need, and only $70. Lots of good reviews, and the software seems to have many options and templates to choose from.

Here's an easy one, no need to do anything except upload your photos. It gets put together automatically.

https://animoto.com

I use animoto as well.