It has something to do whether it's like a suffix to a name or not. Like for example "Alexander the Great". It will never be "The Great Alexander".