I used to have one on my mountain bike, but after I started using a rack and panniers the bike would just fall over. The stand had gouged up the paint behind the bottom bracket, so there was some rust I needed to get rid of there.

A guy I met on a tour this summer had a click stand (http://www.click-stand.com/) and it was capable of keeping his fully load Surly LHT upright. And I mean FULLY loaded, 4 panniers, handle bar bag and a huge rectangular dry bag laid across the rear panniers. It requires the use of included straps to engage the brakes to keep the bike from rolling.

Now and then I'll see someone riding down the road that forgot to fold their chainstay mounted kick stand. I guess they figure that out when they go around a corner.