How do I choose between transparent, semi-transparent, and solid stains?

Transparent stains highlight the grain most, semi-transparent adds colour while showing texture, and solid stains give stronger coverage and a more uniform look.