The best fight scene I have seen for tension and depth is Star Wars VI Luke vs Darth Vader. The best fight scene I have seen for just plain awesomeness is Captain America: The Winter Soldier Elevator Fight Scene
I have to agree with you, the fight scene between Bond and Obanno was pretty intense, especially considering that once upon a time, Casino Royale was one of my least favourite Bond movies, until recently.
My favourite fight scenes generally happen in Jason Statham movies. The actions are always real choreography, which makes the scenes themselves feel gritty and real.
Amazing choreography, wide takes, stable cameras and good lighting always make the best, most breathtaking fight scenes.