Nitnat lake and Squamish BC
Hood river Oregon
Summer is the windy season, where it blows almost every day. Logistics are a bit more challenging, but scenery at these spots is unrivalled. Water is cool at the bc spots, and a 5m would be a good idea for hood.
In the east-
Iles de madeleines
The wind isn't as reliable, but it's a fun adventure out there.