I was lucky in this regard, to have someone who has the drive to create and do things as my roommate. And also another roommate, who was the exact opposite - your standard "go to work, and then watch netflix all the time". First of all, seeing the contrast between those two was eye opening.
And second, the drive is infectious. I usually don't manage to find the motivation to do things on my own, and tend to procrastrinate. But having someone who has the drive, and just joining his projects, will get you the motivation. The best advice for life I can give to anyone is to surround themselves with people who have hobbies you want to have, to join communities and offer help as a volunteer with running it (this is important - don't just join as a lurker, but as a volunteer). Sure, you may not be good at it - but you're no longer doing it for yourself, which will usually end with me giving it up - but the community depends on you. And that's something that helped me tremendously with learning new things, or just getting out and doing something.
Thanks to that, we have a indie studio that is working on a game in our free time. I'm also helping with organizing and DJing at events for our smaller music subculture, because I just offered my help to volunteer and help with it, which has also prompted me to start learning how to do stage lighting, so I can make the parties better - which was a hobby I wanted to do, but never found the motivation. I was volunteering at gamedev conferences, where I've met amazing people that eventually landed me a job, while also not having to pay the ticket for the conference. I have joined a group that organizes LARPs, and even though I had basically nothing to offer aside from a pair of hands and my time, just being in the group chat was inspiring - and it's only a matter of time before someone asks "Hey, we need someone to do projection mapping, can anyone do that?", and you'll be like "Never done that, but I can try". And now you're not just doing it for yourself, so you will get better motivation to do that.
So, if you don't have the drive or motivation to do stuff on your own - find someone to do it with, who has the drive, and help him. It is infectious. Everything I now do in my free time, be it stage ligthning, DJing or projection, I had no experience with when I offered my help to the group of organizers that were doing it. Sure, at first the only thing I did was carry stuff from place A to place B, but just being around those people, in their groupchat and part of the planning they do for events, eventually led to the "I've never done that, but I can try learning it". And if it doesn't work? Well, in cases like that I was the only one willing to try, so the alternative would be to not have the thing in the first place, and if I said "Hey, I tried, it's not gonna work", then nothing was lost.
Also - watch this video. While it's not exactly about finding motivation, it shows that it's ok to not be the guy coming up with ideas, but the world needs more people who are willing to help the people with drive and motivation and embrace their thing.