I have an cheap Nashbar fluid trainer. It's rusty from sweat and the handle broke off long ago so I have to use a vise-grip to tighten it. It also makes a funny jet engine noise until it warms up. But it does what it does. And I don't care because I only use it in the garage or to warm up for races.

You can spend more for quieter ones, nicer looking ones, or ones with variable resistance and power data. But they all do the same thing: hold your bike and let you spin in one place.