I forgot I never finished this thread with a final post, so for anyone following it, I figured it is the least I could do, especially for those who offered advice.
I ended up going with a Sherwin Williams product. It was pretty expensive, (about $50/gallon), but I bought it at the end of the season at a 40% discount, so it worked out to be in line (price-wise) with other stains I had on my list.
I went with a solid stain, and put 2 coats on. It took the better part of 3 full days of work (I did it in October, and got very lucky with the weather).
I did all the prep, replaced any questionable boards, and was looking for a product that would not show any differences in the age of the wood. This SW product was a home run on that requirement. However, two coats was a must. One coat just didn’t give the overall, uniform look I wanted, but that second coat did wonders.
I also paid extra for a couple of things from SW. First, they had a LOT of color choices, but they had 3 pre-mixed colors. I chose on of the pre-mixed options, and it was a great decision. Unless you order a 5-gallon bucket, you would have to mix the gallons together at the deck to guarantee you have a uniform color. With the SW pre-mix, I didn’t have to worry about that at all. Also, the color will most likely be available for a long time. Finally, the pre-mixed color had a UV-protectant mixed into it (I think this was available in some of the other mixable colors, but not positive). This added a few dollars to each gallon of stain.
I applied it with a brush and a roller, and that is THE LAST time I will ever do that. My deck is brutal with the number of spindles that hold up the railing, and I must have blocked out the pain involved the last time I did this job. Either that, or the last time I stained the deck I used a transparent stain, so maybe it went on more easily. I don’t remember. But putting this on with a brush for 80% of the time was just awful. It looks great, so if it survives the winter intact, I have no complaints. Just never again.
To spray the deck, it would have taken me a LONG time to cover everything for overspray, but I can’t imagine it would have taken me nearly the amount of time it took to stain the deck with a brush/roller. So if you have not made a final choice and are holding off until spring, I highly recommend finding a sprayer you can use for deck stain.
As for my initial reaction to the finished product, I have to say I am very pleased. It has been over a month since I applied it, and it looks great. The thing about solid stain that I was worried about was not much of the wood grain would show through. That is true, but enough of it does. The deck still looks like wood (not plastic or some man-made decking product) and it does NOT fill in gaps like some of those deck “restore” products. It has a very rich, deep, uniform color and you can still see some variations in the wood itself.
I also used a wood filler in a few areas where I needed to fill a hole or crack in the wood (used very sparingly, over a few boards), and after sanding, the stain covered these areas nicely. I know where they are so I can see them, but I doubt anyone over for a visit would see any flaws without really looking.
If I remember, I will update this thread again in spring after the winter abuses it to see how the stain holds up. With all of the class action lawsuits on the deck restore products, I feel like I dodged a bullet with going in this direction. I actually purchased some of the Olympic Deck Restore (I think) because it was on sale and that was what I originally planned to use, but after reading this thread, doing some research, and talking to a relative who basically confirmed every nightmare story about the stuff, I took it back without opening it and never looked back. (As a funny story, at the end of summer, right before I finally focused in on the SW product, the 5-gallon restore products were being sold for $20. I think it was their “sell it or throw it out” sale. I am not sure, but my guess is you were buying it at that price with no rights to sue afterward, but I don’t know. All I do know is I paid over $90 for a 5-gallon bucket a couple of months before (and THAT was a sale price), so something must have been decided at the corporate level on that product.)
Anyway, I spent more than I had planned, but I am so far pleased with the results. (And so is the better half, which is always nice.) And my daughter picked the color we used so it was a family win all around!