re: What are some notable program-changing wins?

92 Bama over Miami (actually, January of 93).

I do not know of any game that marked the sudden and dramatic end to a dynasty more than that game. Miami was never the same. Yes, they did come back years later to win a title, but if you remember the late 80's and early 90's, that Miami team thought they couldn't lose and had the rest of the nation believing them.

That game will always be my favorite moment in college football history.