I just browsed through some of the Rails Day 2006 applications for which there's a live demo available. Most of the applications were nothing special but one of them really got my (proverbial) vote right away:

Pingup solves a simple problem, which any geek with a little scripting mojo can solve using existing tools. Pingup just makes solving the problem a lot easier.