Off the top of my head, the only movie I can think of that went up in its second weekend was "Titanic". As Tino pointed out, the numbers of "Borat", while impressive, are a bit skewed because it expanded to so many more theaters this weekend.
A lot of hype? I know of no one who's interested to see this Bond. Hell, I've seen all the last Bonds in the theaters of the last twenty years and I'm skipping it. I'm sure it will do well, but I can't remember the last Bond that was some monster blockbuster (because they weren't) and this Bond has less going for it then most, IMHO, because people have no connection to the person playing Bond.
JMHO. Then again, I don't think Happy Feet will perform particularly well this frame either. I think a lot of people are getting burned out on CGI Animated flicks thinking most of them are not really very good. Look at how many came out this year, and how well they did. A few hits, but a lot of mediocre performances as well.
I'm with Chris on this one. I don't think Happy Feet is going to do all that well. Look at the last two weeks. Personally I was actually more interested in Flushed Away than Happy Feet (though I have no intention to see either). The only thing that might boost the numbers for Happy Feet is all the people going in to see the Harry Potter trailer with it. It might make the number one slot, but I'm still banking on Bond. Though this Bond does have less hype surrounding it with the general audience, it's still looks to be an excellent action flick and that will bring in the numbers. It's got me excited - particularly because it's been said numerous times that the producers scaled back the production from the last few (which was definitely needed in my opinion).
Of course I'm really rooting for Borat to deliver the big upset and remain at number one!