Do any OS X twitter apps integrate well with Notification Center?
Tweetbot supports the Notification Center and adds clickable notifications that open in the app itself.



It does not intercept the standard Twitter notifications Mountain Lion added though, but as you mentioned, you can disable those to only see the Tweetbot ones. You can still tweet from the Notification Center after disabling standard Twitter notifications.