I think a lot of people speak on insulin without first hand knowledge or any actual research, its really not that scary.
You arent dying from a 10iu shot of humalog before bed if you accompany it with a meal of adequate carbs (preferably some complex). Hell, the dose could be much higher, your body will wake you up long before you die.
That said, that isnt how I would use it but I have been doing a shot of Humlin R at 6pm, done eating by 9 and sleeping by 10 without issue.
Mike Arnold has a few good posts on a PM thread about this very subject (how hard it is to actually die from insulin use, even when attempting to suicide via insulin overdose).