It is indeed a Hummingbird Clearwing Moth. Specifically a male. I live in CT, close to the RI border, and they are indeed common, given the right plant. Here is the female from my own photographic work.
The plant this one is on, Bee Balm, is a particular favorite, where they congregate in great numbers during full bloom.
Great job in capturing it! Certainly one of the hardest things I've ever photographed myself.
