Richard Wright for Pink Floyd was the first keyboardist that came to mind - I dont know what type he played, but as far as contributing to a bands sound, I cant think of any other bands where the keyboards worked so well and didn't make it sound like funk-a-delic or the capton and tanell (SP) or something.
Billy Powell from Lyndard Skynard was great too at helping the bands sound and it still sounded like hard rock and not something light weight like elton john or barry manalow.
Generally, i hate keyboards in rock bands, but these are two examples where, imo, they worked very well.