I'm interested but cautious about getting too optimistic. I love D&D and things like it, and really want more D&D games, but I feel like, personally I want either 1 or 2 things.
1.) A full-on Baldur's Gate esque adventure with companions and a single-player story (not necessarily utterly old school gameplay wise, just in scope. Like...a Bioware game! Like...I want writers involved and a lengthy, hefty, single-player experience with party control and deep mechanics (though I also think there MUST be concessions for it being a video game - Temple of Elemental Evil and Baldur's Gate played SO damn slow because it seemed like they just took the rulebook and plopped it into a video game. BG2 was a little better cuz you were at a higher level, but still slow, I thought.
OR
2.) I want another Baldur's Gate Dark Alliance style game. A little less hectic than Diablo but similar in style. I think a pulled back action rpg would be SO much fun with the D&D license if they put the time, money, and effort into making it a good one. I'd want it single-player/co-op (local and online) interchangeable. So, say, a 4 character party where you control one and then either have other players' characters and/or AI characters.
I'm not convinced Sword Coast Legends is going to do either of these things. It looks hack and slashy to me which can be okay (if going route no. 2), but I'm worried that they foreground the multiplayer so much...I'm an antisocial gamer. If I had friends into D&D, I'd play actual D&D with them. If I'm playing a video game, I at least want the option to be left alone and immerse myself.
Time will tell. Ultimately, it's going to depend on how well-developed the single-player campaign is. I liked NVN, for instance, but got bored real fast with only one companion who never talked and a story that never really grabbed me. I liked NWN2 way better in that regard (except for how freaking impossible it was to play because of how buggy it was omf GOD it made me mad). Anyway...single-player campaign will determine my interest.