I think the journey of figuring out how to actually create with AI has been as interesting as what I'm able to create. I wish I had documented more of my lessons-learned the way you have. The biggest challenge I've found is that, as you mentioned, AI often thinks more equals better. So I had to learn when "comprehensive" meant subtracting over adding. Of course, there was also the practical reason, that more documentation meant more tokens used up - more context consumed - for a given task.
As far as files and rules, since I like seeing things visually structured, I've had luck creating temporary html files that visually capture the structure (files and rules) of a given effort. I use that as my visual map and it's what I have Claude use for its own understanding. It reduces the need for reading entire docs but it also forces me and the AI to stay structured. I also mirror this in that (as of late) I use Cowork for the planning (i.e. the maintenance of that visual mapping) and Claude Code (in a completely separate instance) to run the task(s) and, in the end, pass the lessons-learned over to Cowork manually. Otherwise if they were one "mind" e.g. when I would use Claude Code to coordinate AND code, it would always add more information to its memory and it would get out of hand very quickly. Ultimately, the key for me was understanding how AI uses structure. For example, when I started using Linear a couple of months ago - prior to which I had no "formal" project management system, all of the tags and labels and 'projects' (as Linear uses the term) really helped manage efficiency in productivity. I use Linear's MCP to connect to Cowork directly and always start sessions with reading 'project' titles, labels, priorities, etc. before diving into details for a given effort.
I wouldnt say that tech skills dont matter at this point because thats wrong. My experience is the only thing that helps me to say like "hey thats not the best solution for this, you better do this", or at least to doubt at AI's judgement and send him do a proper research about different ways to go... But the truth might be that managing skills worth more nowadays
As for motivation: I need to pay bills, all I can think is "I need to build more"... :'D