I spent a week in August in a hostel around Long Island City. It took ~10 minutes by subway to get to Midtown, another 15 or so to get anywhere else in Manhattan. The main drawback is that you can't easily walk there - you have to go across the Queensboro Bridge. Walking back to LIC late at night is much more of a hassle than walking back to say, LES or Hell's Kitchen.