Nothing close, most things have bottomed out unless you are looking for a couple hours of travel from Denver. Waterton is regularly run, but being October boaters are becoming scarce.
Nice thing about Waterton is it is boat from the parking lot, hike back out. So no need for a shuttle, easily scouted and walked. If your into soul solo boating your good to go. Biggest issue I see is the weather, they may cut flows with all the moisture and this cold front. Friday looks clear but a little cool in the fifties.