When I started with Sonar, I knew how to record and mix with other tools.
It was too much for me to immediately start capturing recordings using a computer. I would record using a Tascam 2488 and export the tracks to Wav files and import them to my computer for mixing in Sonar. That way, latency really didn't matter at all. I did all my tracking on the Tascam and all my mixing in Sonar.
I had years to learn the FX and automation techniques and the DAW in general starting with a 2002 version of Sonar and more seriously with Sonar 6.
When I started tracking using Sonar, I was already completely familiar with the FX. I'd watched videos and read books. I had a handle on it. The only thing I had to focus on was tracking. Punching. Loop Recording. So, the scope was focused.
I feel you on 'there are too many things to learn'. It's no fun to be overwhelmed. So try to slow down. Pick something you want to do in Sonar and get that to work.
BTW, the changes in the X series were almost entirely organized around trying to make it easier for new users. There is still a contingent of hard core users that are afraid the X series will make them less efficient so they don't upgrade.
IMHO, X3e is best yet. I wouldn't want to be stuck using anything else.
And ask questions in the forum. Don't be a stranger. Also, trying to answer questions in the forum will show you what you do and don't know. Once you can teach Scook a thing or two you'll be getting there. :-)