I've lived in lower Manhattan and Brooklyn since the 90s, so I'd be happy to help with recommendations and advice. My partner (and better half) Samantha is an NYU master's student of history who has visited literally every museum in NY, so she's a trove of information as well.
We've been delighted to host a wide range of travelers, including couples on their first visit to NYC, newlyweds, retirees, students, families with children, LGBT...we have an open door policy. This is Brooklyn, after all!
Brian & Samantha