Other than playing "Black Hole Sun", I have F-all idea on when or where or how to use it, honestly. My tastes are like yours, but I can think of no iconic songs, artists that use them, etc. that I have to have in my repertoire.
It would make sense to have "organ"-y songs for the funk project I play with, I guess, but....we have an keyboard player that does that.