I’m glad you stayed there and can attest that it was good.
OP, either LGA or JFK is best for Brooklyn. Queens is right next to Brooklyn. No bridges or tunnels or State Lines to cross. If you wanted to sight see in Manhattan then a Manhattan hotel would make sense.