Experience with Modafinil/ Provigil, anyone??

I've been on antidepressants since 2018 after being diagnosed with MDD and anxiety. The medication along with occasional therapy, worked wonders for me initially. Within 1-2 months, I felt like a completely different person, I felt MUCH MUCHHHHHH better. However in 2022, I started facing problems again. I changed doctors and struggled with severe insomnia (i think that's what it was) I often stayed awake until 5/6 a.m. and woke up around 7 p.m. This disrupted my ability to function, attend college or even perform basic tasks. My psychiatrist then prescribed sleeping pills which helped me fall asleep but I still slept through most of the day and felt excessively sleepy after waking up. If I saw a bed or a comfortable chair during the daytime, I'd immediately doze off. Recently, I visited my psychiatrist who prescribed a medication called Modafinil (Provigil) 100 mg, twice daily – morning and afternoon. Looked it up on the internet and found it's often used to treat narcolepsy, which might explain my excessive daytime sleepiness. I also read that it’s considered a “smart drug” and has been life-changing for many people. A YouTube video I watched about it was pretty fascinating.(Scary too lol) If anyone has experience with this medication or knows someone who does, could you share your thoughts? Does it really live up to the hype?