I think Github's issue tracker is the best around, now that search actually works. Very lightweight, and the integration with commits and pull requests is really nice.
dhh doesn't sound like he was ever a fan of Lighthouse: https://twitter.com/#!/dhh/status/63366853636009985