There are a bunch of great ones in the western mass and CT area but depends on what you want to target. The Harrison Brothers run Harrison Anglers out of the Deerfield watershed but they are now licensed in NY as well so they will hit the Deerfield, Hoosic, Housatonic, Millers, Swift, etc. for mostly trout but also do pike trips as well. Another good one in the same area is Chris Jackson. If you want one for the Farmington in CT I'd call Up Country and they can connect you with a host of different guides. Further down in CT you can target more varied species like carp, smallies, as well as trout and pike and I'd recommend a younger guy Rowan Little. He just had Tom Rosenbauer out and they slayed massive carp. Jon can recommend some in PA and there is Master Class Angling if you are looking to go up to Champlain which has amazing variety.
Thanks for the input, a lot of those names sound familiar as I've been doing a good amount of research on google, all of them pretty much have great reviews from newbies to experienced fly guys. I live in Northern RI so Mass would make more sense, but don't mind driving further. There was one that seems to fish the swift a lot as well, I heard that river does well in the heat of the summer too. I have a place in NH as well but unless I'm missing something there doesn't seem to be as many guides in that area as I thought. Those white mountain streams have definitely humbled me lol.
But anyways, I think I have a great fathers day gift now we'll both enjoy once I nail something down. Hopefully I'll be able to contribute more to this thread in the next couple months.