Most museums are uninspiring and out of touch, with dust-covered neglected artefacts the main attractions