Yes, flatbeds can be good - most people here use epson flatbed scanners. The pick of the crop is the epson V700, which takes 4 strips of 6*35mm frames, so you can setup and scan 24 frames in one go. It's around £400 though.
The epson v600 is the next model down, and this has room for 2 strips of 6*35mm, so 12 frames in one load on the flatbed. Image quality is basically the same as the V700 (technically not as good but there isn't much in it). These are around the £200 mark.
What sort of volume of scanning do you want to do?
If you have lots to do, you can also investigate a scanning service - i believe these come in around £1 per 35mm frame, so it's not exactly cheap, and I also believe they will offer discounts for large volumes.
Cesare