Hey, I'm new to the digital world of making soundtracks and music. So I apologize if this question seems repetitive or simple minded. How good is Sonar X1 LE? By this I mean does it offer the most/least tools than any of the other brands? How well does it compare to Sonar X1 Producer, Studio, and such? I'm curious. Thank you, and have a good day. Nathan.

Welcome, Nathan.
The Sonar LE packages have traditionally been capable, but extremely sparse. Basically, you get a lean version of the Sonar DAW environment, with none of the extras that make it fun to work with. The most frustrating part of LE is that many of the tutorials direct you to things that do not exist with LE.
If you are looking for an inexpensive way to get a feel for Sonar X1, I would suggest Music Creator 6.
It is based on the X1 format, and is a more complete package than LE. It does have limits, such as only two audio inputs, but it includes some basic soft synths that are not present with LE.

As you can imagine, all LE versions of all DAW software are surely designed so that you reasonably soon want to upgrade to a paid version. The limitations are designed so that you get almost there.
That's what they are for: Giving you the very basic features and introducing the workflow.