I'm quite a fan of the new styling, but partially simply because it's NEW.
We were talking about this the other day on IRC, actually, and I think that Marfig and I - though having similar goals - are oddly disparate on this.
I have wanted a reason to like Windows again ever since Windows 2000 died. XP was alright to me but as I grew more interested in security and operating efficiency, I grew to realize what a bloated monster it truly was and how little of a space it had in a security- or productivity-focused environment. I tried, first, to redesign my UI with programs like LiteStep and other shell replacements...but I just couldnt' get away from the overarching design. I grew to hate using it at home and work, and over time I gave every computer I had to Linux and MacOS.
Media Center Edition (both XP and Vista/7) was a disastrous attempt to slap an ugly 10' interface veneer over a desktop, and it felt just like what it was - an add-on that showed MS was not serious about the idea that people were using computers differently than a desktop. There was no true understanding that the data and its uses were changing.
MS has consistently stuck with the "desktop, startbar, icons" since Windows 95, and outside of the office, people don't use computers as a repository of editable documents anymore. Computers are instead portals to content - be that websites, social media, games, video, or music. We use computers now to consume much more than we do to produce, and the UI has not changed to catch up.
Given this, whether Metro is just what the doctor ordered or a complete and utter bollocks attempt to force a tablet interface on a desktop, I am for it. It's the first time I've looked at an MS operating system and said "Now THAT will allow me to interact differently with my system." It's designed for media consumption and it *could* work at 10', 2', tablet AND phone sized interfaces.
As far as a home-use OS goes, I'm excited to see whether this turns out well. And if it doesn't, I hope MS doesn't take the wrong message home that we need to go back to the desktop/startbar/icons. I personally want to see more of this "ditch the desktop", and hopefully they'll pair it with the Kinect SDK.
THAT would be something to see...