Stupid as it may sound, even in this market, most hiring managers run screening as a systematic search for disqualifiers.
The most important thing to remember here is not my opinion on the validity of the question or the reasons any hiring manager gives you for how important the data is to them. The important thing to remember is this: most candidates don't have interesting reasons for leaving their previous jobs.
No matter what any hiring manager tells you about their preferences, the reality is that giving a boring answer really can't disqualify you. Nobody runs hiring processes that select only for people with interesting last job quit stories; they'd reject almost every candidate! But an "interesting" answer certainly can disqualify you.