How is it really living close to Lake Union or the waterfront?

The scenery is obvious, but I wonder which nearby areas balance convenience, noise, and daily movement best once the first impression fades.