AE can do all that, Sound Keys would help you with keyframing the beat/music, and various native plugins and animation with transitions... the thing is that AE is a very complex piece of software that can do a lot of things, but very few are drop and render type. You will have to get into the software and create the slideshow yourself and it will be as good as you are in mastering AE.
What you may want to look into is project templates.
Here's a few good resources:
http://dropdrop.com/
http://www.planetaep.com/
http://bluefx.net/store/
http://www.freeaetemplates.com/
Tudor "Ted" Jelescu
Senior VFX Artist