I can answer your question. I am on Long Island also. I have the chargepoint but previously had the Tesla charger. The chargepoint is a better unit. The chargepoint can charge at 50amps. Your model Y will only charge max 48amps. I charge at 32amps just because I find it's more than fast enough anyway. You apply for the rebate online and they will either deduct it from you electric bill or send you a check. You set the charger to only charge between 11pm - 6am and you get time of use rewards at the end of the quarter. The only downside to the non-tesla charger is you need to use your adapter that came with the car. It's simple.
Tesla chargers don't have as many features as the chargepoint. The chargepoint has an app where you can turn it on and off, set time of use, see charging activity with estimated cost, see kwh in, estimated miles in, see monthly trends, it will remind you if you forgot to plug in by a certain time and a few other things. It also has a desktop site that gives you more stats. It comes with a removable plug for an outlet or you can hardwire it. It's easy to install.
Tesla charger just charges at 48amps max. Doesn't need the adapter. You will need to open your charging door by taping it with your hand vs pushing the button on the Tesla charger.