The most common and most likely answer to this crossword clue is the 9 plus 4 letter word BIRDS-EYE VIEW
I've seen this crossword clue in The Times
B
I
R
D
S
-
E
Y
E
V
I
E
W
More clues leading to the result BIRDS-EYE VIEW
Buddy explains!

The straight part
We know that "A great sight" is the straight/definition part of the clue. The straight part is often a synonym or definition, in this case a great sight = birds-eye view.The cryptic/wordplay part
In cryptic crossword there's often an wordplay/cryptic part as well.This part involves a more complex hint, such as an anagram, homophone, hidden word, etc.
Sadly, We don't have an explanation for this specific crossword clue yet.