Looking for a good flying club to get to from Brooklyn

Hello all !
I just moved from France to NYC, and currently live in Brooklyn (Bushwick).

I am in the process of getting an FAA license thriugh foreign license verification, and I am looking for a flying club, preferably non profit, not too far from home in transit + cab or transit + walking distance.

I checked a few posts from this sub that were interesting but which are starting to be pretty old (pre-Covid), so I'm not sure if they are accurate anymore.

It seems that my best bet in terms of transport convenience (or least difficulty...), would be to check FRG. I am struggling to find which club to check out though (any feedback from Long Island Aviators?), and am also finding that ISP, though further away, could match a bit more the vibe I am looking for (any feedback from GACE flying club ?) .

Do you have any feedback/recommendations ?

Thanks !