David Hepworth charts our fascination with that most earth-bound of gods, the rock star; and discusses some of music history's striking examples (R)