"You Know My Name" and "Skyfall" were both outstanding, although I prefer the latter because I think female vocals go with/are more traditional for Bond movies than either rock songs or songs from male vocalists. That doesn't mean that there aren't good examples of either, such as
"Thunderball," "Live and Let Die," or "The Living Daylights." There are also female-sang title songs that are the drizzling shits, like "The Man with the Golden Gun," "All Time High" (Octopussy), "Die Another Day," etc.