If somebody volunteers that they'd rather be a professional surfer than a software developer, then spends the whole interview bringing it up, then that's a red flag. If you explicitly ask them to spin a flight of fancy then judge them for not having pursued it, then you're an extraordinarily unfair interviewer.
For instance in game development there are lots of roles including designing and developing. If I am hiring a developer and you say you want to design that is a very valuable piece of feedback that doesn't exclude you from the position. For instance it could mean that of the two positions one may be a better fit because it involves more architectural work.
In your example that isn't nearly as useful, wanting to focus on your hobby is not a negative at all.
An example of a problem would be hiring for a legacy system and having someone say they want to work with the latest and greatest tools. The reality is that isn't going to happen and the fact that you are going to be looking out for another job quickly means it would be better for both of us to avoid the hire (again all things being equal).
If we posit a dream world, with a different set of constraints, then why shouldn't you expect the answers to be different?
If you ask for one dream job, and I have 9 dream jobs, including software developer, dance instructor, and grad student, how do I provide the example you're looking for? If I choose wrong, how does that affect my job chances?
Out of curiosity, I looked up the history of '110%'. https://books.google.com/ngrams/graph?content=give+110%25&ye... shows that 'give 110%' started in the 1960s.
Reviewing Google Books, 'give 110%' comes from sports. "Sports, Games, and Play: Social and Psychological Viewpoints" (1979) https://books.google.com/books?id=yKNMmmec8jgC&pg=PA114&dq=%... gives a lovely contextualization:
> So we devise terms to describe our heroes an heroines and place them on pedestals so they may act as models. We develop a whole new jock vocabulary that incorporates all of the cultural models. Our winning athletes ... give 110%, they never say die, play with pain, or give till it hurts.
Then in the 1980s, the sports term started to get used in business. One of the earliest matches for "110%" I found used in this context is an ad in the Rotarian, a publication of the Rotary service club. In 1986 you could by a computer that was "110% IBM" - https://books.google.com/books?id=EDYEAAAAMBAJ&pg=PA62&dq=11... . Within the next few years, the phrase became much more widespread. I think this 1989 ad for Mennen brand deodorant https://books.google.com/books?id=dmuI3YaWtAIC&lpg=PA7&dq=11... makes a clear connection between sports and the managerial class.
Then by 1991 there was the business book 'The 110% Solution: Using Good Old American Know-How to Manage Your Time, Talent, and Ideas'.
Sports, boosterism, and business school, all wrapped up in one conveniently impossible phrase. The language of jocks now fully repurposed to maximize production.
Simplest example is tech stack. If it is COBOL job and you say you want to work in Haskell that isn't a no-go thing, but depending on how passionate you are about it, it does point towards you not lasting long due to discontent.