Honda CD110 seems to have got some good reviews among the biker forums online. It has better fuel tank capacity, moderate engine capacity, 8.25 bhp @ 7500 rpm power. Only thing that it misses out is the mileage.
TVS Sports seems to be more of economical model but doesn't have a good fuel tank and engine displacement. On that part Honda seems to be performing lot better. For most of the spec TVS performs really good. However in terms of bike lifecyle, it does not have much good reputation.
Yamaha Saluto RX seems to be in between these two bikes. It has decent fuel tank capacity, higher engine displacement and better power at 8.25 bhp. However do note that in terms of mileage it's not as good as TVS Sports. In terms of lifecyle of bike, most of the Yamaha model have decent lifetime value. So it's worth investing into.
So if you are looking for long term investment into the bike then maybe either Yamaha or Honda is the model to go with. Though Honda has some pros and cons but in terms of lifetime requirement you have mentioned, the bike seems to be performing good and continue to do so.