Yes Sonar is more than capable of producing professional results but like most things in life it's not quite that easy. Sonar is just a tool for audio production, the user needs to know how to use the tool to get the best out of it and the desired results.
From your post it sounds like you are just starting out. If that's the case then welcome, music production can be very rewarding but there is an awful lot to learn and the learning curve can be very steep.
Sonar is as good a place as any to start that learning curve though and this community is full of knowledgeable users that can help make that learning curve a little easier, although it'll still be steep.
Good luck, and if you do decide to buy Sonar you'll find loads of help here.