I've had good luck with both Kurt Kinetics and Cycleops (the fluid trainers in both cases). I had the Cycleops for 15 years, and it was my primary form of exercise when I lived abroad in the 90's. My ex. got it when we divorced, so I replaced it with the Kinetics.
The weight is borne by the axle/skewer on the rear wheel, and I've never felt like there was a problem with holding me up. I weigh 220 - 230, but I've seen larger folks use these just fine as well. I'm sure other brands can handle it as well.
FWIW, Kurt Kinetic publishes a power curve for their trainers. That's useful if you want to see how you're progressing. With a Garmin speed sensor on the rear wheel, it's easy to convert the speed plot to power.
Last edited by jonathanb715; 05-09-11 at 05:18 PM.