Prompt when sending text message as SMS instead of iMessage?
This is something I wish iOS5 had. Alas, it does not - however if it fails to send as iMessage with send as SMS disabled, it will allow you to tap / hold (I forget which) and specify to send as text. 

The main caveat to this, though, is that it doesn't 'alert' you per-se.