Oh I definitely agree Sonar should never try to be a video editor; what I'd love to see though is an improvement in workflow. Right now I do a variation of what both John and Craig suggest, preparing my video files in Premiere and doing any final striping/output there.
The hassle is, if for example I'm doing sound design or music for a commercial and they recut it (which happens about 4000 times on an average commercial haha), I then need to line it up in Premiere, create some kind of picture in picture to reference in Sonar where the changes are, and make sure it starts at the exact same time (they always seem to put a different amount of black before each version). If Sonar supported multiple video file layers and the ability to easily line them up, I could have all my versions accessible from within Sonar and easily reference back and forth any changes.
I realize these kinds of features aren't really high on the list for most people who use Sonar strictly to create music - but I think it really could become a powerful post audio tool with a few enhancements like this... easier said than done though, I'm sure!