"A freeway"
There's not much to say about the Brooklyn Queens Expressway as far as reviewing a street to live on or visit because it's a freeway. You can access it starting at the Williamsburg Bridge and you can access both airports, Queens / Long Island and the Hamptons via this freeway. Traffic on it is pretty standard for New York City but there's no avoiding it if you're trying to do a quick summer beach visit (unless you're going to Jersey). The only bad part about the freeway is that it's not exactly pleasant to live on any of the streets that are directly under it.