I have both type of experince with honda activa. I purchased my activa in July, 2006. It has average fuel consumption 40-45 KM/L. It has comfortable riding and has good handling and pretty looks.
The problem which I am facing with this two-wheeler is of to start it in the morning.
It not starts in the morning with out using chowk even in the summer season. Useful only on city roads. It is useful for ladies and old age persons. I think it does not have long life. It is average two-wheeler. Its accessory is very much costly. Petrol cosumtion is also avergare. So in honda activas cost you can purchase a good bike from the market.
But after all these things I want to say that there is no loss in purchasing this vehicle. You can use it for a long time if you take care of it properly.