Nizan, know that you are not alone, I'm having similar struggles.
So far I have fragments of perfumes - One really nice and very complex modern and unique base that accidentally worked - but I don't know why it works, one formula that has a nice drydown but the top and middle were cloying and brash. I currently have easily 15-20 2dram bottles of failures. Yesterday I worked all day on making an Egyptian kyphi base for use with white florals. I used, among other things, myrrh, sandalwood & frankincense (standard kyphi). I combined my ingredients with some angelica root tincture as a fixative... blech, too much myrrh and too much angelica tincture, the frankincense disappeared, I CAN'T WASH IT OFF! Not only did it fail miserably but as I sit here typing I smell the syrupy, hormonal, animalic and sickly medicinal myrrh smell that haunted me in my sleep, I now despise myrrh, hahahaha! I'm exaggerating a little bit of course but you get the point. This is proving to be a very challenging, stinky, frustrating and expensive activity, lol.
I'm now contemplating my next exercise. I think it might help to study some old and standard perfume recipes, make a few to see how they develop and age and read some more books... one can never have enough reading material methinks. Making different accords might be useful. Although I tried the PA leather accord, six weeks later it doesn't smell anything like any leather I've encountered and it's certainly not something I would use in a perfume, I'm not even sure how to make it better. I've read that it's supposed to be a bare bones accord but it doesn't even come close so I'm not sure how bare bones and "not even close" relate.
I'm curious to hear how others have navigated these treacherous waters because I don't really see a way through as of yet besides trial and error. I'm thinking it might help to look through freely available formulas and make them. From a known successful formula new things can be added, subtracted, existing materials multiplied and modified. This would help by teaching what works vs what doesn't work. I'm beginning to think that this method of jumping in feet first with no reference point is the wrong way to go about it. It might be helpful to travel well worn pathways before forging new roads into unknown territory. Know what I mean?
Does this sound familiar or is your struggle totally different?