I have most of the larger ones for a long time, more than fifteen years for some of the oldest ones. The cacti rarely flower indoors for me though, the big mammilaria used to flower every year but that was when I lived in a house with no central heating during the winter and it hasn't flowered for about five years, we lived in a house with a large heated conservatory for the past two years but it didn't flower there either, and moved into our own house in January so maybe it will flower again here. Some of the succulents do better indoors though, christmas cacti that flower in november, the stapelia has flowered for the last couple of years and some of the aloes, the euphorbia obesa has flowered for the couple of years I've had it. I have a nice pot of sedum morganium that has a few flowering stems at the moment but they're very insignificant flowers. And a pot of ceropegia woodii that flowers pretty freely, they have quite small flowers too but they are really beautiful if you take notice of them. I have a few orchids that have flowered this year too, phalenopsis, paphiopedilum and a big brassia so far this year. I know that the cacti would be much more likely to flower if they were in the greenhouse over winter but I have no heater for it in case of freezing weather and I'd hate to lose any of my older ones.
Here's a couple if pics of the brassia and stapelia from about a month ago.
http://i215.photobucket.com/albums/cc280/fluffy_stitch_jodi/IMG_0754-1.jpg
http://i215.photobucket.com/albums/cc280/fluffy_stitch_jodi/IMG_0749.jpg
And a paphio from last november I think.
http://i215.photobucket.com/albums/cc280/fluffy_stitch_jodi/PA110160.jpg