I like Delmar Alarm Clock. It does what you describe. However, you need to modify your power settings to not shut off when on AC power if you want to use its alarm.
Its what I use daily. Plug it in, set my wakeup time, and it dims when idle. Even has a nightlight.
http://www.delmarit.com/ditalarmclock/
Cheers!