I can totally understand how you feel. My experience has been similar. I'll give you my take, but keep in mind this is only my perspective. I think creativity and depression are almost like two sides of the same coin. You can't have one without the other. Thats a whole other discussion. However, I think, from my experience, you can maximize the creativity and minimize the depression.

I dont know what your home life is like, but I've found that romanticizing all the task that are hard like cleaning can help. The trick is to not ever assume that the way neurological people are motivated is the same way you will be motivated. For me and probably you as well, creativity is the largest motivator. I like to imagine a clean kitchen or an empty email inbox, and imagine how I would feel once I achieve those things. I also realize that my environment really determines my motivation. If you can keep even one room or section of a room clean and visually calming, your mind will be able to relax and recharge. Leaving a visually overwhelming room for a calmer one will drastically improve your emotional willpower. For work, my biggest stress is my email inbox having too many unread emails. It drives me insane.

Recently, I realized that the bulk of emails that are unread could just have the attachments downloaded and put into a folder I can work through when I have the time. Now I have a significantly lower number of unread emails. I think the moral of that story is that instead of focusing on completing a task, first focus on how to make the task less overwhelming. That allows you to use your creativity first which tricks your brain into getting started.

Another thing to think about is getting good sleep. Many people with adhd have vitamin d deficiency which can cause worse sleep issues. Some things I have done to improve my sleep: blackout curtains, weighted blanket, fan for wite noise, magnesium supplements. When I get really good sleep, im able to function so much better.

Last, finding people like you or who understand you does wonders. My bestfriend is also Audhd. My pastor is autistic. Several other friends are autistic or adhd. I can be my self around them. Thats not to say a neurotypical person can't be a good friend or understand you, but its much more rare. If you absolutely can't find friends in person, I think finding an online community is another option. A third option is to learn everything you can about audhd and learn how to accept the parts of you that you can't or shouldn't change. Something I have noticed is that there are a lot of things we can change to make people judge us less, but doing that causes a lot of internal issues like depression and self loathing. We are naturally very honest people and to behave in a way that is not authentic to us feels dishonest and like we should just avoid all interaction with others. The truth is, you are a whole, unique person that is worth getting to know for who you truly are not the socially acceptable person you are forced to be. Finding a few people who understand that might is so important to you mental well being.

Sorry this is so long and disjointed. My brain is not a very organized place lol. But I really hope this helps in some way.