Admirable how you have set everything up in Obsidian!
I’m not sure if you are open to considering using another app for this—if you are, maybe check out AmazingMarvin. I’ve been trying to set up my project/task management system in Notion for ~18 months. My system in Notion was somewhat similar to yours but not as well structured. It eventually fell short but (I think) I found the ultimate solution which is AmazingMarvin. The “notes” function of AM is a bit lacking, and it’s not the easiest thing to use and has a fee. Just want to throw my suggestion out there in case it would be helpful to you.