Blood Bowl is possibly one of the greatest tabletop games ever created. BloodBowl Cyanide is... a decent enough translation of that game to the computer, with the rules all translated pretty well barring the occasional glitch. At the current steam sale price of $7, you'd be doing yourself a disservice not to try it.
As to what the game plays like, it's more akin to Chess than Madden, with a fair amount of risk management thrown in. You of course need to score as many touchdowns as possible, but failing certain actions ends your turn, thus you need to be mindful of exactly what risk you are taking. Players can gain skills and level up, letting you tailor your team to a specific playstyle, but they also can debelitating injuries and death.
Just be prepared to throw yourself into MP, as the AI is garbage. It'll fool you into thinking it's cheating by performing outrageous plays, only because the nature of bloodbowl is that 1/6 times something will work no matter what, and when it falls flat on its face immediatly you dont realize what multi-layer insanity it was attempting. MP is alive enough anyway, with peak hours having anywhere from 200-350 players online, and at dead of night (when both USA and EU are asleep/working) there's still 30-50 online, so you can always find a match.
Also, do yourself a favor and search for and download the "Community Content Pack". It's 100% compatible with MP, and just adds a bunch of graphical niceness, such as extra skins for players so you can make sure your linemen all look different. Just make sure to go and delete the 256 color submod (Data/Manager/Colors folder) or else the team colors will get screwed up in matches between people who do and don't have it.
Lastly, before you play, go to http://bbtactics.com/
and read the starting rosters sections, these will give you the most effective starting rosters for all the races for a new player.
Also this is a https://www.youtube.com/watch?v=zHSq3BR35JE
rather long TotalBiscuit segment showing exactly how the game plays, so you know the playstyle.
It's up to you if you think the price difference between this and Chaos Edition is worth a mesely 3 extra races, ontop of LE's 20. Both have access to the same MP lobby, and can play each other, so unless you REAAALY need to play as Chaos Dwarves, Khorne, or Underworld, LE will do.