"A Small Matter of Programming" by Bonnie Nardi is an excellent book which delves into the history of end-user programming. Spreadsheets, CAD and so on, all based on researching users.