The Warhol is really enjoyable and they do a great job mixing up the archival "stuff" with the fine art and with other artists' works -- it sits well together, but is differentiated clearly. If you're a fan of Warhol, or at least curious about him, you will enjoy yourself. If you've yet to make up your mind, a couple hours spent here will set your position one way or another. As for me, I had just seen another Warhol show in another part of the country and seeing a bunch of his work together was the first time I really "got" him. I think this museum would have had the same effect, had I seen it first.
So to sum: not sure about the hype? You'll get it after this museum. Already bought into it? Then you'll be rating this place five stars.