Avoid Behr for staining. They make excellent paints but IMO their stains aren't nearly as good. I personally like Thompson's but I know there are many who aren't fans.
If your deck has any kind of age to it avoid transparent stain, I'd go with semi-transparent if you still want to see some of the wood graining.
Also, find a day/days when you know it's not going to be too windy. First time I did it there was a pretty stiff wind and stains are so thin and watery compared to paint a good wind will blow that sh*t everywhere.
I'll also add to avoid Pittsburg. If you're going to Menards, go with Cabot.
Deck stains also have a lot of negative reviews that aren't warranted, as well. People don't prep well enough or at all, blame it on the top coat and then go online blasting reviews everywhere.