I have a softspot for Die Another Day, because it was the only one I had as a kid, and I'm one of the 6 people who like the theme song. I agree it is not fitting for Bond.
I actually really enjoyed Tomorrow Never Dies, but I wish Brosnan had gotten more serious films that were written better like Goldeneye.