What are the pros and cons of going with a solid instead of semi-transparent?

I live in MO and I have a deck that is 14 years old but was never stained. It is on the north side of the house and some of it never gets direct sun ...