I have been using Activa Since 7 years, and its still Running smoothly. I enjoy riding it on daily basis.
If we talk about its Mileage, so it used to give more mileage when it was new as compared to now, but still is is better than bikes and all other Two Wheeler.
It is very comfortable, made for 2 but as we are Indians so it can carry up to 3 or 4 people.
It is very reliable, runs smoothly even on some bad roads. perfectly balanced so no need to worry if it is going to slip.
It looks Great and Runs smoothly even after many years of use, so in my opinion you should go fir it.