Nobody enjoys museums - so why do we bother?

A few art historians aside, we all visit museums and galleries simply because it's expected of us, argues Anthony Peregrine