You've hit the nail on the head.
I think everyone knows Nostr can be REALLY confusing to new users (e.g. @Natalie Mojo works at a hosting company and just today she mentioned how the learning curve for Nostr is rather steep - and she works in technology all day!)
But it's also confusing even to developers like me who are coming from different backgrounds. Much of the discussion feels like it's in Greek or something and it takes me a while to get the gist of what's being said.
There's so much in the Nostr-verse that's possible, but people can't figure it out, so they give up when they try to do it. The folks writing the code aren't writing documentation, so it's really hard to use what they build.
Case and point - I'm in NY, so can't use ZBD. My host (Natalie's company) was setting up notstream for me and I didn't know how I was going to receive payments since I couldn't use ZBD. I saw that nostream could use LNBits but didn't know how to get it working. Finally, after combing through the nostream Telegram group I found a single reference that linked to a Nostr thread that explained it and I was able to figure it out - and it works!
I think if you find pain points and explain to people how to make things work you'll find success. I'd also suggest you find ways to insert yourself into the process so you can monetize your work.
Personally I'm not big on videos or audio. I like written instructions that I can follow step by step (preferably with pictures!)
Good luck!