How to be woken up when receiving a text message with an Android phone?
I went with Tasker, it is a bit cheaper (especially when you realize that you are less likely to need plug ins with it, though it can use Locale plug ins it seems), it is trickier to get running, but allows for a much wider range of options than Locale. 

So when it sees an SMS come in with "PROBLEM" in the subject, it turns music playback to maximum volume, and then starts playing a song in a loop, until you click on the stop button. I need to add the feature to not trigger again for a few minutes (to deal with the flood issue).

I looked at Setting Profiles web page, but have not tried it.