Many of the ones that have been mentioned...
....and one of the greatest of all that has yet to be mentioned...
Rocky Raccoon checked into his room
Only to find Gideon's bible
Rocky had come equipped with a gun
To shoot off the legs of his rival
I have always loved the White Album and this song in particular has always been one of my favorites. Definitely a story song and definitely very cool.