Hyper-focus is not great, nor is it some form of "super power" that adhd people have. Its any time that somebody with adhd is able to focus on something. People without attention disorders can focus willingly, people with adhd cant.
The difference is that the adhd brain is deprived of euphoric dopamine until you have that "hyper focus" activity that the adhd mind begins to depend on.
People with adhd are highly prone to becoming mentally dependent on activities like video games because of this euphoria. However, I find that being medicated appropriately and focusing on what I want to focus on is more rewarding than the activities I depended on pre-diagnosis and treatment.