Dalton was the most true to the character, imo. Craig had glimpses in his first two movies but TWINE Skyfall, Spectre, and The Unbearable Wokeness of Bond were so fucking boring and generic that they will forever taint his legacy.
Overall, the best has to be Moore. He had a couple really good movies, a darker movie in Golden Gun, and a couple of mediocre movies that were at least fun to watch and had catchy music and hot girls. Connery was ok, but Goldfinger is massively overrated and everything after that was a slog. (But still better than No Time 2 Die.)
I grew up on Brosnan Bond, and even as a kid I knew GoldenEye was his best movie. It's basically the unofficial 3rd Dalton movie. TND was okay (I love it for how 90s it is), and TWINE and DAD had some moments, but he was obviously phoning it in during the latter half of his tenure. I don't know if it's Babs taking over as producer, or making Pervis & Wade permanent writers, but after TND the series really started going to shit and I don't think it will ever recover. At least it won't until society itself changes, which I'm not sure it will.