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.