Technical/science museums in general often seem to be closer to this ideal than other museums, because while some of the artefacts may be valuable, more often they are trying to showcase how things worked rather than specific objects.
If you're ever offered to visit the archives/warehouse of a museum, accept. Showing (large) stuff is expensive in space, so most exhibitions are only the tip of the ice berg of the enormous amount of stuff the museum has collected and stored. Often an exhibition is a mix of well-known artifacts that visitors expect to be there (and are therefore included, but are not very interesting as you already know them), some artifacts that are good specimens over-all to show (but not necessarily that interesting), and some truly interesting pieces (you probably never have seen before). I found that when you visit the archive/warehouse of a museum, curators tend to show artifacts from that last category in particular.
Though, the computer history department is a bit too small and similar in size as the equivalent Science Museum in London. In both you find a Cray super computer, first Zuse computers and many older mainframes and terminals, etc. But everything is death, every historical computer sits just there. There is no interactivity, what a shame. They should at least re-work a Cray 1 or 2 super computer and let visitors play around on its terminal - that would be awesome.