Museums are the most useless lots in the game. I can't imagine how any player would enjoy watching their sim's stare at picture on the wall or sculptures for hours on end. I'd rather see my sims dance, socialize, actually do something. I think the art gallery in San Myshuno is slightly better because there's an art studio and small bar area where your sims can do things.
That said, I might keep this museum, because Hollywood does have some museums about movie history, but maybe I'll just enhance it with some interesting objects the sims can use. All the other museums will be deleted.