I want to thank everyone who has posted on this thread with info. It was the first thing that I read when I found this forum several months ago.
I am a SW resident and used Water Street to go almost anywhere by bike since I retired from work at the start of 2011. Before that I also often rode to work at NRL via the South Capital Street bridge and Bolling AFB. I used Water Street to cross the 14th Street Bridge or to go via West Potomac park to the CCT or anywhere in MD. Now I have to use Maine Avenue, either the road if early or the sidewalk if there is traffic.
I suspect that even when the redevelopment is completed it will be a much more difficult situation for bicyclists — of course I may be too old by then anyway. 