It's interesting to note which current powerhouse programs were pretty inept in fairly recent history, a la Alabama, as you note.
Clemson might be another example, not sure. Is there a program that was a powerhouse in that period and now is inept? USC? UGA was pretty mediocre 1996-2002.