That’s been my experience with FCP’s media manger, as well. It’s as good as what you give it. If you’re tapes are logged properly (ncluding reel names!), and you’ve done the all-important “Make Sequence Clips Independant” step it works pretty well.
If all of your media was crash captured using “Capture Now”, and your reel names are spotty, then you’re just SOL.