This is just one of those few things that the Droid (or Android) happens to do quite poorly. But have faith! Check out this thread:
Text Message Vibrating Alert
"Ring Toggle" is what you want. You get a ring, ring+vibe, vibe, and silent; and it blankets everything on your phone (texts, calls, voicemails, emails, etc.)