When an old "friend" showed me Oblivion, I was hooked and so fourth hooked on single-player RPG. I despised MMO's with the exception of Guild Wars because the community is tolerable and no monthly fees. Its what got me into PC gaming after all!
Now don't get me wrong, hearing rumors of TES online years back gave me skeptical thoughts, to the point where I was worried. But sure that faded away after no word but now that TES Online is confirmed, I have new thoughts an why single-player faithfuls should at least give it a chance!
I am still a lore buff in training, and I have read GREAT things in lore about the second era so I am excited to see that. But what makes it better that it is in the 2nd era is that your legendary characters the Nerevarine, COC, or Dragonborn are unaffected. Plus, we get to explore Tamriel again!
But lets get something clear, TES Online is being made by Zenimax Online Studios, Bethesda Game Studios has nothing to do with it so don't hate on Todd!

But Lady Nerevar in another post put it best into my thoughts as well: Cautiously Optimistic.
I am only worried about how it looks and hopefully no monthly fees (Like Guild Wars)
But optimistic about the lore and Tamriel as a whole!