David Bowie missed out on a leading role in the Lord of the Rings films because of his role as an evil goblin king on the big screen.