Your choices are distemper, emulsion or royale, This is asian paints speak, should be the same with others. Look at the costs per litre ? some time back prices ranged from Rs. 70/130/190. For most uses emulsion is good enough. Distemper if its for somebody else. They always show you that tile with the royale on it and say see how smooth it is along with one with distemper and say see how rough but when i ask for tile with emulsion they say they do not have one
So question now is what do you mean by 'good'. Range of colours is very large with AP.
How well the paint works depends on how well the surface is prepared, sanded down or puttied up.
A royale foundation takes more work but you can still use emulsion and get those mirror smooth walls. Dampness makes a big difference, damp walls are not going to allow any brand paint to adhere for any length of time. Fix the dampness before painting.
If you need to paint the whole house, try to find a big shop, the prices will be cheaper than with smaller ones and make sure you are the one buying the paint and not the painter.