At first I was "...eh...." and now that I've listened to it a few times, I like it. It is a lovely song and Sam Smith's vocal styles are not my favorite, but I can live with it.
Definitely not in the upper tier of theme songs, but I still rank it above FYEO/ LTK/ GE/ TND (the Sheryl Crow version) and naturally, that steaming turd of a "song" that is DAD.
But, how hard would it have been to slip the word "Spectre" somewhere in the lyrics? Really, Sam Smith? You DO know what the actual title of this film is...don't you?
Even Jack White was able to get "solace" into his song. Tsk tsk.