It depends. If I get into a really interesting book, and then spend several hours reading, I sometimes feel like that. Like I got so sucked into the world of the book that I left this one. Sometimes at the end of a really long, really good movie I feel the same. It doesn’t feel as bad as you describe though. Just kind of disorienting.
If I get into a flow state at work it feels fantastic. At the end I feel tired, but in a good way. I can relax and usually kind of revel in whatever was created during the flow state. It feels so good, I have to be careful not to overindulge. If I don’t watch it, I’ll ignore all the boring work that’s not likely to get me into a flow.
I highly recommend anyone with ADHD to look into flow state theory.