I just bought a new trainer, and I really like it. Now dont get me wrong, riding on the trainer sucks!! but it definitely beats not being on the bike at all. I work at a shop, so I had the advantage of trying several out before I bought anything, but I found that CyClops is prob the best out there. There is a quick release where you mount your rear wheel (and it comes with an extra skewer), so there is no screwing in/out or centering your rear wheel. I believe CyClops owns the patent on this design, b/c it is the only trainer out there that I found that has this option.
As far as what type of trainer you get, a lot depends on what you want. I would NOT suggest a Wind trainer b/c they are pretty loud and not very smooth. Mag trainers are pretty nice, and you can buy them with the option of a remote to increase/decrease the resistance. Mags are much quieter, and smoother, but it can get annoying when you dont have the progressive resistance. The Mags are probably the most economical way to go. The FluidII trainer (which is what I have) is nice b/c of the progressive resistance. But, they are much more expensive. If I did not get mine at wholesale price, I probably would have gone with the Mag+.
Google Cyclops if you want to find the different trainers on the net, and find out what prices you can get from performance or colorado cylists, and then head to your local shop and see if they will match the price. Most shops will match, or quote slightly above, internet prices, plus you dont have to pay shipping/handling. And, it is SOOOO important to support your local bike shop!!
If you have any other questions, let me know! Good luck, and good for you for wanting to keep fit after hitting a little bump in the road....
"There's something about getting grimy and sweaty with the gals. You feel like you're breaking the rules. You're not made of sugar and spice and everything nice. You're not someone's girlfriend and you're not someone's mother. For that moment, at least, all you have to be is a cyclist." -Kimberly Grob
"Live strong, Live wrong"