Long Dark Night is much better than I Can't Stand It No More, but to each their own...both are not all that great on the album though, they sounded much better live
and it is a treat to see and hear.
http://www.youtube.com/watch?v=py-9fiDrzI0
When Fogerty played the pre-game at the Super Bowl a few years ago, his voice sounded awful and he and his band didn't sound too hot either, so I'm glad he was so good on Letterman.