Personally, I found skeuomorphic design to be something that I really enjoyed, for a couple of days, but rapidly got sick of.
That may have more to with the skills of the implementors, as opposed to the concept, as a whole.
I do find modern "flat" design to be less "fun," but I get a lot more done with it.
That might be the thing. In real life you don't use the same stationary for years. Your desk is a reflection of your mood and evolves almost daily. Maybe that's where these fail?