Test Track, Buzz, Splash and the Mine Train all have ride pics that will show up. Those are the ones we did. Dinosaur, Everest, RnR and ToT have them too, not sure which others.
Not sure about where other magic shots are, but I know I had one done on the walkway/bridge near the Mine Train and Be Our Guest. It was Lumiere sitting on my hand. There was also a video that showed up that had an animated Lumiere where his candles blew out and lit back up.
There were about 5 pics that showed up from the mine train, and a video as well, that showed a short section of the ride with your car in it and then some stock footage and music.
These show up if you are wearing a magic band on the rides. And you don't have to have memory maker to get them, we only had the regular Photopass, of course you have to buy the pics and you can't buy or download the video (maybe it is included with memory maker though, not sure)