Okay, here's my thoughts on every card.
Lowly Squire - Blizzard likes to add random 1 drops into the game to showoff new mechanics and this time Lowly Squire is here to show us the Inspire ability. Personally it seems a bit weak to me because it doesn't play very well on curve. It's actually slightly weaker than the modern undertaker, I'd say. Too slow for 1-mana.
Nexus Champion Saraad - You really need two draws for him to be considered good, so it basically has to survive a full turn to get value. Plus you're basically forced into hero powering for a couple turns. Feels pretty slow. At best it fits into some kind of crazy hero power combo deck but otherwise seems mediocre.
Frost Giant - Interesting Card. It fits best into decks that use hero power a lot, so either handlock, face hunter, or very slow games. I don't know that he really fits into Handlock. Probably costs too much for Face Hunter. Don't think you can count on all your games being slow enough to justify it. Probably weaker than Mountain/Molten/Sea Giants but stronger than Clockwork Giant.
Coldarra Drake - I kind of like the idea but unless this is combo'd with Maiden of the Lake it doesn't seem that exceptional. I don't know if Mage Hero Power decks will really be a thing unless some much stronger mage-based inspire cards come out. Seems early to evaluate it fully but I'm not sold yet.
Maiden of the Lake - Eh.... the body is unimpressive and seems kind of bad as a Turn 5 play. The effect is interesting but is probably on a minion that costs too much mana. I think it's a bit clunky.
Lock and Load - This is the kind of card you build a deck around. Maybe we'll see some kind of mid-range hunter that runs double tracking and double hunter's mark. Maybe like pre-nerf buzzard hunter but runs this instead of buzzard. You need at least 2 draws for value, 3 draws for playability in constructed. Seems like a very good card.
Skycap'n Kragg - "Charrrrge" makes me laugh. Seems like he could easily be a staple in pirate decks? I guess it all depends on if we get some sticky pirates in this expansion. Probably decent enough at 6 mana but I think 5 mana is the goal. So getting two pirates on the board might be difficult.
Totem Golem - Extremely powerful on curve. A very strong tempo play. Easily a Shaman staple in Arena. A nice thing to pop out of a Piloted Shredder too. Might herald some kind of tempo Shaman deck in constructed?
Effigy - Works extremely well in a high curve Mage deck. Maybe you put this in Echo Mage? It's kind of like a better version of Resurrect. Also disgusting with Mad Scientist, like most Mage secrets.
Thunder Bluff Valiant - Kind of a win-more card I guess? It's like bloodlust but not used strictly as a finisher. Or maybe like Quartermaster. A strong threat if left untouched as the effect could easily stack, making 4/2 healing totems or whatever. Could be strong and give people even more incentive to clear out totems.
Draenai Totemcarver - Feels very strong. 1 totem and you get a 4 mana 5/5, which is extremely good. A 4 mana 6/6 is even better. I think this could be a very, very good card.
Kodorider - EVERY KODO, GET IN HERE. Doesn't combo very well but two kodos for 6 mana plus a hero power seems ok if you can afford to hero power on the turn you play it. Kind of slow but getting two kodos out of this thing is kind of insane.
Tuskarr Totemic - At first I thought this was 2 mana which would have been BUSTED, lol. At 3 mana it's kind of like a Razorfen Hunter at worst. Maybe you put this into a tempo shaman deck that runs all the new totem cards, just because having more totems is good. And if this spawns a Totem Golem, that's bonkers. Flametongue or Mana Tide Totems would also be pretty awesome. That's like a 1-in-3 chance to have an insane turn 3 tempo play, and standard value at worst.
Fallen Hero - Feels like Steamwheedle Sniper in a class that can make better use of it. An instant pick in Arena if you can get it. Kind of glad this is a Rare and not a Common. In Constructed, it might fit into some kind of hero power deck for mages but I'm not sold on that archetype.
Ball of Spiders - Already talked about this a bit earlier, might be overcosted by a single mana point for Constructed and doesn't really fit into the hunter's gameplan, but I understand why it is costed like it is. It's like a slightly worse Nourish with a few extra 1/1's attached to it. Possible that it combos well with Scavenging Hyena, but that might be too gimmicky.