I can only speak personally. Producer is definitely worth the extra to me, as I have felt far less need to invest in third party products since upgrading.
Apart from all the instruments, I would miss the two PC compressors that come with Producer - the PC76 and the PC4K Bus. I use them all the time.
IMO Addictive Drums is far better for most needs than Session Drummer, even though I don't use it much - I already had Toontrack stuff. If I hadn't already got the Toontrack stuff, I would probably have been happy with addictive Drums, and stuck with it.
So, I think the extra for Producer is a great deal, but only if your hardware is up to it, as others have mentioned.
Spending money on upgrading an underpowered computer is the only reason I would see to buy the Studio version. Even then, I would try to save a bit more cash and upgrade my computer AND get X3 Producer, if at all possible.
Let us know what you decide, and come back with any questions. I upgraded to X1 from Sonar 6, and would have been lost (and bald) without the help of this forum, and Scott's "Sonar Power" books. Another great book is "The Power in Cakewalk Sonar" by William Edstrom (It is about X2, but still covers most of the workflow in X3, and comes with a DVD).
Good luck.