I hhave the ABBA Super Bike Stand, with Front Lift Arm. I have a video review, there's plenty out there. For about $350, it's a complete solution for lifting both front and rear tires pretty darn easy and safely.
All those stands are sweet. Keep in mind storage is an issue wih any stand that's welded together and that sort of thing. That's one thing I really liked about the stand I chose, when I'm not using it (98% of the time during riding season) it can be stored on my pegboard system.
The ABBA also has a roller option, but it's pretty expensive they ask about $200 or so for it. But it allows you to move the bike. AFAIK it cannot be used in conjunction with the frnt lift arm though. So it's not as function as the few stands being mentioned here that remain assembled.
At any rate, Don't bother with those old hoop things unless yo have to. Pitbulls are nice, but if you get one of these, or an ABBA, or a Heindel, they're so much safer and easier to use overall. None are completely idiot proof though, of course. ABBA makes a competing product, you should check it out, call the Skylift. For about $900, it's a bad mofo. I think it does a few things these stands do not (I think).