The best I have seen were in Northern Saskatchewan in late August and in the Gulf Islands, B.C., in September.
You don't neccesarily have to be that far north, but it has to be dark when you are likely to be up, which is not the times of year that people are likely to be cycle touring.