Very pleased to say I've never seen it. It doesn't appeal as a general proposition anyway, but the prospect of listening to Brosnan singing is the primary reason why, despite being lent a copy on DVD, and had it sitting in the lounge for about four years, I never once got round to watching it.
Oh absolutely, and I freely admit I've not seen him in anything else. I just find him a tad wooden in the Potter movies. He might be outstanding on stage or in other movies. Watson took some time out to go to university hence has been a little less prominent, but I don't know what Grint is up to.
I'm not convinced the guy who played Harry Potter in all the movies is up to much either- yes, he was young, but the kids who played Ron Weasley & Hermione Grainger were leagues above him.