I've always said that with an orchestral re-arrangement (like cutter does, for instance), this theme of McCartney could be a good love/tender theme for soft scenes; specially considering that the first notes of the main melody are very Binary Sunset-like (listen to 0:05)

http://www.youtube.com/watch?v=ir-Pl4szYOs&feature=related

Then the song turns to an orchestration and melodies that couldn't function well in a Star Wars movie. But I'm of the idea that nothing is going to fit perfectly, everything that's not SW will need at least, some minimal arrangement/tweak, that's why I'd rather look for melodies instead of "finished" songs.

Greetings!