Nothing can prepare you for the press of people even in the off-season clamoring to get into the Uffizi -- who's main claims to fame are:
1) being the main museum in Florence
2) a forgettable Michelangelo
3) one stiff da Vinci and one musky da Vinci, both forgettable.
but while there you might turn a corner and see something like this http://upload.wikimedia.org/wikipedia/commons/b/b4/Piero_di_...
which would be just at home in a surrealist installation at the MoMA as in the Uffizi.
But I do have to agree, the never ending pictures of punctured saints with long faces, Madonna and Child's and Crucifixes does get tiresome. At least there's always Caravaggio to make things interesting for the modern audience.
On the other hand, understanding the entire sequence of western art - of Grecian art, its loss and the elevation of stark, religiously themed art during the dark ages, followed by the renaissance and onwards, makes western history and an important chunk of many modern unspoken assumptions make sense.
In other words, starting with Middle-ages art but moving onwards is an effective and memorably way to hack the meta discussion humanity has been having about itself through the ages.
Someone else already said it, but I do believe that that the biggest reason for the difference in quality between old art and new art is that old art has had the benefit of the filter of history; for the most part, the bad stuff got thrown out and good stuff survived. In geek's terms, you might say that the old stuff that remains is sturgeon's 10%, but that 90% of the new stuff is, in fact, crud.