The Notifier app's Alerts tab has entries for a few popular apps (Facebook, Twitter, Google +, Gmail, Calls, SMS messages), with a button that lets you see a complete list of every app you've installed and assign vibration patterns to them.
This is how it works: open the mVip app to create and customise up to 7 vip groups, in which you can define vibrationpatterns in combination with an assigned LED color.