Hmmm. I think just during combat, since there are places where you do genuinely need to be looking upwards, like in the elevator shaft in the Prologue.
I don't think there's anywhere I wanted to look straight down, though.