It's not that they're terribly loud (the wind unit), but they generate quite a bit of vibration that will travel through the floor if you're not on a concrete slab. I have no idea about the blackburn unit, my advice would be to go to a bike shop and try out the different models and see which one you like best. I have nothing but good things to say about the CycleOps fluid, even though it mostly serves as a display stand for the blue deer

Edit: I used my fluid trainer for two years while living above a family in an old SF apartment with no complaints. I rode it every morning from 6am to 7am. So I don't think you'd have a problem with noise as long as you get the fluid version.