I don't have the Studio version yet but I've owned and used the regular version (original hardware) with Sonar for two years and for the purpose of the question I don't think it makes a difference. Maschine is great for anything requiring good electronic drums. The sounds are excellent. Its own internal engine is great for compiling kits and loop based recording. Its integration into a DAW is not ideal, because all the workflow ingenuities are built around the idea that you'll sequence inside Maschine itself. That said, if you set it up right, you can make it work linearly inside your DAW too and it's certainly a better drum computer with better sounds than anything else I've ever had. I have never regretted my purchase.
As a controller, I don't think it's excellent, but perhaps the Mk2 hardware, being color based, is better. I have never used Matrix View in Sonar and use my APC40 with Ableton so that's why I never dove in. When I tried to use Maschine as a general Sonar controller through ACT with the Mackie protocol, it failed miserably. The best results are had with the VS700 protocol, but even that is far from ideal as some functions don't respond correctly, something which was implied by Cake officials to be a failure on Sonar's part. Additionally, Maschine is built to be a great controller for Maschine, not for anything else. I suppose the Matrix View might work considering the 4x4 pad arrangement, but for most stuff that's just not a very useful layout.
Just my experiences, hope it helps.
EDIT
Oh yeah and I really like compiling my kits, adjusting sounds and editing samples from the hardware. Gives you much more of a feeling of working with an instrument.