You also mentioned, I think it was Ronin1973 that new users lack knowledge on triggers, gates, clocks etc. I think you hit the nail on the head right there.
-- Groc
I read your whole post. But this line jumped out at me the most. If we were to write "the book" one of the biggest recommendations would be to download and install VCV Rack. The basic system is free and there are a lot of free expansions. It's an entire Eurorack-style ecosystem that will allow you to add and play with modules using virtual Eurorack standards. When you're trying to get a feel for what is a trigger, gate, clock, CV, etc. it's an invaluable resource for learning and trying things out hands on. You'll walk away with a lot more knowledge of how modular works in the real world... by doing. I can't stress it enough.
Eurorack is tricky to get your mind around coming from DAWs and hardware MIDI. I think people get comfortable with virtual plug-ins and traditional MIDI instruments that are far easier to use than control voltages. Being able to recall complete patches and using a working INIT patch means little thought has to be given to HOW different components actually communicate with each other. In Eurorack, you literally have to make the connections between components by hand.
As you discover how CV works, you'll notice a lot of very basic modules can really unleash the full power of such a retro method of making synth sounds. It's that level of control that, personally, brought me to Eurorack.
It's all good. I hope you stay around for quite a while and post frequently. I'm still learning a lot as well. There's always an interesting way to do things.