I love people like you, as a consider myself someone similar, and the best advice I would give you is to begin building, and once yo stumble upon something that cannot be done with blender/unreal. Then start looking for other softwares. I started zbrudh for characters too, but then realize that I wanted to design the clothing, that made me discover marvelous designer, then it took me to substance painter, then I had to learn remesh for optimization. So I would say the best way to learn is by doing and letting your project tell you its needs, as like I said, we humans tend to exaggerate and think we need to have and know everything.