For me (as a novice user (n00b)) of any type of DAW I found X3 (and X2) a real learning curve - first couple of weeks was really frustrating, I expected my devices to work on plugging them in.
There is a fair bit of messing around before I felt comfortable with the preferences setup. Once that was established, all the routing was so confusing, though much to lots of help from others here in the forum and also lots of reading and watching vids, I think I've progressed and making some use of Sonar.
I think I would have had the same experiences with any other DAW though (I did mess around with Cubase in the past, (some years back I come across some hacked version using some kind of virtual driver key, O2 or something) and found similar frustrations at the beginning too.
So I would recommend keeping it simple to start with and build on it as you gain more confidence with Sonar...
Your probably best to go with Sonar Producer too and later you may want to get full version of some of the Light Editions that are bundled...
Edit: BTW don't be afraid of Windows 8.1, it's awesome, just make sure to keep it up-to-date using windows update - its been very stable, better than windows 7 infact..
Jim