Yes. Quite often my obsessions do not fall into the useful category, in which I research and learn all I can about a topic. Quite often they just involve me getting focussed on a particular character from a TV show or something and I just keep imagining scenarios or conversations with that character over and over. It often gets to the point where I can't sleep, but I usually manage to still think about it while I'm doing the housework so I don't get too behind. I do slow down, and I lose a lot of motivation for doing other things.
What I have noticed is that I tend to do this a lot more when I am stressed. Like if I am starting a new job, or going on holiday, or am battling with the new discovery that I'm autistic. Having noticed this, I now use it as a measure of my stress and anxiety levels. If I find I am thinking a lot about a character then I stop and look at my life and consider if there is anything that is causing me to be worried. This doesn't stop me imagining, but it does mean that I can then think about how to deal with the thing that's bothering me.
I also find it helpful to work out what it is about that character that draws me to them, and what that tells me about myself. When I was in high school it was Phantom of the Opera, and I can see that I was drawn to him for his lonliness, his being an outcast. Recently I had a thing for Phil Coulson (from Marvel), and I think that was about the way he always does what he believes is right, and goes around saving people. I want to be able to save others too, but perhaps in a less dramatic way. I also use him as an inspiriation when I'm scared of doing something, usually because I'm scared to talk to someone about an issue.
_________________
Your neurodiverse (Aspie) score: 149 of 200
Your neurotypical (non-autistic) score: 73 of 200
You are very likely neurodiverse (Aspie)