What capabilities do you require that something like scmbug doesn't do? I'm not really certain what you expect integration to really mean.
I think generic integration solutions are less important now because of the hooking capabilities of both Subversion and Bugzilla. Using Bugzilla's web services, you could add a pre-commit hook that communicates with Bugzilla and decides whether to let the commit proceed. You could add a post-commit hook that updates something in Bugzilla to show the commit. You could add an extension to Bugzilla to do whatever in Subversion when a bug has been resolved, but that strikes me as being a dicey proposition.