I think Dalton's accent is cooler than Connery's.
Blasphemy, I know.
I'm aware that Connery's Scottish brogue is so iconic that we just let him do it in every movie regardless where the character's from, and it is very badass. But...Dalton's voice just strikes me personally as cooler. I love his rustic Northern accent sort of poking out from under his RP dialect ("Whoevah she wahhs, I most'ave scahhhed the living daylights outta her!"). It really works for his character--he's still a charming gentelmanly Bond, but just under the surface is an angry no-nonsense soldier. Having traces of a sort of working class accent in his voice reminds you of that.
If you must blink, do it now.