When I can't get to The Lake I train on the Fox River, which is conveniently located just a few blocks from work. On South wind days, which are common during the warm months, the wind blows against the current just like it does in the Columbia River Gorge... only on a not-quite-as-windy scale. Still, even these calf-high waves are enough to get the board planing for a few seconds, allowing you to switch to surf-stance and enjoy a little ride.
Of course, if you want to do the downwinder you have to paddle upwind first. You'll notice that in the first part of the video I'm working hard to make way upwind. You know what they say... ain't nothin' free in this world. Hope you're getting on the water. Enjoy.