Really disappointed in that choice. It may only play in the opening titles, but the theme always plays a massive part for me. I'm biased though, because something about Sam Smith just annoys me.
In terms of Craig's themes in general, Adele was safe but brilliant. Jack Black and Alicia Key's effort is disliked by most but I didn't mind it. I think Chris Cornell's is by far and away the best though. Hard to make a rock song with Bond elements without it sounding corny. I don't know what fans in general think of it, but I'd put it up there with the very best Bond songs.