This is one of title sequences I have created. On this project I created all the motion graphics, including the title sequence, text on screen & font design, up-scaling the standard definition video to HD. For the photos I would first adjust them in Photoshop, creating layers which could be moved independently in After Effects. I would import those assets into After Effects and create smooth motion with depth that would fit the story. Those would be rendered out and imported into the final edit.