Some of the overlooks are drop dead gorgeous. Some have less of a view, or the view has become obscured by overgrown trees and shrubs. I live near the north end of the parkway, and they do a pretty good job of maintaining the views (even opened up one view recently that has been blocked for years) but I've heard differently from people here about the part in NC. You may just have to see as you go.
https://blueridgemountainstravelguide.com/best-blue-ridge-parkway-overlooks/ looks to be a reasonable list of ones with great views. I can confirm that #1-#4 all belong on this list. There are a couple other overlooks in this area that are really good too, so I guess I suggest slowing down as you approach an overlook and decide as you go. If you have someone on your tail, pull into the overlook and then decide.
https://www.virtualblueridge.com/parkway-places/overlooks/ lists all of the overlooks, with descriptions for many and pictures for some.
https://www.nps.gov/blri/index.htm is the official NPS site, with good info. This is where any closures would be listed. Usually it's just due to winter weather but there is one road washout near Roanoke.
Keep an eye on other traffic. October is very busy, especially weekends. While you are slowing down near an overlook and judging the view, the car in front of you may have stopped dead. Also watch out for bicyclists and even pedestrians. I sometimes run on the parkway but rarely in October.
Consider using an app like GasBuddy to see where gas stations are. You almost always will need to exit the parkway and descend to the valley to find a station. Don't cut it close, some parts are pretty remote from services.
Sometimes the best views require getting out of your car or off the parkway. Humpback Rocks at MP 6 has a tremendous view, but only if you hike a trail a mile uphill to the rocks. There are probably some waterfalls like that too, mostly in NC. Driving up to the Mill Mountain Star gives you a great view of Roanoke. The Biltmore in Asheville is just off the parkway. Even if you don't want to tour the house you might like seeing the grounds.