As far as the "yuck" factor goes, I'd venture to say that PT's clean, streamlined interface beats Sonar's clunky, Windows 3.1-esque facade hands down (I own both).
As far as actual recording goes, I think you'll be happy with either. Personally, I get more done in PT, mostly because the key commands make more sense. But then again, Sonar is no slouch, and I've gotten quite a bit done with it, too -- no complaints.
The only thing that I would worry about with ProTools is the voice limitation. You only get 32 voices in LE (meaning 32 mono tracks or 16 stereo tracks, or some combination of the two), and for some people that might not be enough. 32 tracks should be enough for most music mixes, but I have run into problems when doing sound for video, using lots of sound effects on different tracks and such. Sonar (IIRC) gives you an unlimited number of tracks to work with.
Aside from that, you just have to decide which hardware you want to use. The 002R is pretty nice, and so is the 828. I believe you can use PT hardware as an interface for other software too, so you're not stuck using Pro Tools forever (correct me if I'm wrong), so I'm not sure what MichaelM means by saying Sonar is "much more flexible." I'm not personally aware of anything significant that Sonar can do that PTLE can't (aside from 5.1 mixing which is Producer-only)...
So yeah, either way is good, I wouldn't lose too much sleep over having to choose between two very capable recording packages.