A friend at work yesterday told me about iDive. He gave me a tour of it at lunch and I downloaded the trial and captured a few tapes.
What I was blown away by was how good it is at logging a tape based on scene detection. It will also create thumbnails (at specified intervals) or capture the video to the DV codec or an RT codec. It has keywording. And most importantly it exports FCP XML so you can very easily add clips to FCP. For 69 dollars, I think it's pretty it's sweet. It's essentially iPhoto/Adobe Bridge for digital video.