you can try Clock Pro HD
If the app in background, you will get notification type alarm (can choose several sound type)
If the app in foreground, just sleep/turn-off screen, you will get music alarm, fade in sound, etc.......
Clock Pro also have countdown, timer, world clock, etc
Great replace for Clock app on iPhone, IMO