I personally can't stand it... and I've heard it in other arenas too? although Mtl could well have started it, I just wish they'd finish with it.
I think you're thinking of something else. I've heard the Montreal goal song was specifically created for the organization. I could be wrong myself, but I'm pretty sure Montreal is the only one who uses it.
I don't think Anaheim even plays a song after goals are scored. They probably do, but all I remember from the last game is just playing their goal horn(which I may be biased in saying so, but I think it's one of the best in the league) for an extended period of time. If they did, they could play "what if god was one of us" for Pahlsson.
I didn't go through this whole thing to see if it was mentioned, and it isn't a goal song, but the Flyers used to play "Dude looks like a lady" by Aerosmith for Jagr when he had his mullet-fro. They'd just play it at some point when he was on the ice, I don't think it was a goal song.