I have a fluid trainer and it is fairly quiet. I use it during the winter when there is too much snow/ice on the roads, but it is BORING. Depending on your tolerance for cold, I would recommend getting outside during the winter whenever possible, it's very invigorating.
I do not have any experience with rollers however.