I turn it off when I'm not using it, which is typically weekends ... I have to have
some boundaries.
My Curve sits on the electronics section of my kitchen counter where my charging station is (yeah, seriously, hubby got me one for Christmas for all my toys) at night next to or on its charger if necessary. I have it on a quiet or vibrate profile at all times. I can't hear it at night when it's on the kitchen counter since that's the opposite end of the house from my bedroom.
When my husband works graveyard shifts I do put on the Phone Only profile and put it on my nightstand in case something happens to him while he's driving home from work. The LED indicator does not disturb me. I sleep like a rock.
My BB runs just fine with this usage and I charge it every two to three days when it gets down to about 20 percent.
Curve doesn't serve as an alarm clock for me. Hungry dogs bark in the morning to wake me up if I've slept too late.