I rented the apartment for a month while helping a family member recover from surgery so my purpose was not tourism and we didn't travel into Manhattan frequently. The location was perfect for us because of the great shop on the corner, easy walking to bus and train, YMCA 1/2 block away (which I joined for a month) and easy walking to many other places. If you do take the train to Manhattan or drive, it takes about 1/2 hour.
Other things that worked well for us were the large bathroom (with many towels!) and abundance of natural light. The bedroom is in the back, so is quieter. I slept on the pull out sofa and that was fine despite using it for an entire month. The living room is on the street but it was quiet enough that I was not usually woken by noise - only once or twice. There is a fire station 1.5 blocks away so you do hear sirens during the day, though that seems to be common throughout NYC.
The kitchen is fine. There are many pots and pans. There are a few little things that need tending to like the fridge handle and the faucet which does not swing easily.
The washer and dryer are right outside the door and take quarters. This is convenient although I found the dryer weak and just hung my things in the apartment to dry.