I was dragged through a million museums as a child, and I've dragged my family through their fair share as well. I felt obligated to expose my kids to art, and I still do, to an extent, but more recently I've come to terms with the fact that the giant museums are just too much for our collective attention span, which is about 90 minutes.
On a recent trip to Madrid, we skipped the Prado and went instead to the Sorolla museum, which is in the artist's former home. We enjoyed seeing how he worked and lived, all in like an hour. That was enough. In Florence, we checked out various cultural and historic sites where we saw tons of art, but we skipped trudging around the Uffizi. It's ok, really!