SMSNotify keeps your iPhone vibrating when there’s an unread SMS.

http://cre.ations.net/blog/post/smsnotify--keeps-your-iphone-vibrating-when-theres-an-unread-sm