I've always felt that Brosnan did the most acting of any of the Bonds, even if I preferred Connery in the role. Connery has much more of a physical presence - he seems like he could kick your ass. Brosnan doesn't, but I like the jaded, world-weary quality he brings to the role - he doesn't just drink and womanize because he can, but because he's kind of damaged, and because he's chosen a career where he can die any minute. That quality declined a bit with each of his Bond films, but I liked it initially.

I'd point out that Bond films really are not the place for slashy subtext, but I'm sure you already know that :)