What paint to choose for staining walls?

What paint to choose for staining a particular room, what features should be considered and what to pay special attention to?

Such questions are asked by many. Rooms such as a bathroom and kitchen have high humidity, the living rooms are more dry.