It's not about the biggest, most expensive, or the BEST for me, it's about something that I can be somewhat proud of.
You've made an important point that's worth dwelling on.
As you wander the byways of this forum you will discover many technophiles who go to extraordinary lengths to get the sound they're seeking, such as modifying their microphones, customising their preamps, using particular valves . . . and so on. You will read people advising that "you can't do a proper mix with headphones" or that a Rode is no match for a Neumann, or that "room treatment" is critical. These bits of advice are all true . . . but how relevant are they?
I believe there is plenty of room for the middle ground . . . for people who have moderate aspirations for their recording endeavours and are not seeking to emulate George Martin. And this middle ground is a vast playground in which you can get reasonable results.
An important concept is 'fitness for purpose'. There are many reasons for recording: to make money, to establish a reputation as a recording engineer, to catalogue one's material (like a photo album), to experiment with sound, to have fun . . .
All these are valid reasons for recording, and each has a level of quality associated with that purpose. There's is no need to go to the lengths of recording in London, mixing in LA and mastering in Sydney for a three minute track to be played at a wedding for your friends. In fact, you rfriends would probably be quite happy with something you recorded live onto a cassette. It's fit for the purpose.
However, the recording process is inherently educational, and we learn in increments. I note, for example, that you have recognised there was an aspect of your recording that you were not happy with, and that you are now trying to fix it. That's the way it works . . . we do something, and after a while we learn to recognise its failings. ANd with luck, we discover how to deal with it. In this step-by-step process we gradually improve our craft.
So, there are many people, say, who mix with headphones. Is it a big deal? Not really. In time they will recognise the inherent problems in doing that, then move on to the next step of their development. And so it is, I believe, with all aspects of recording.
Incidentally you refer to dynamic mikes and overloading
the DP004. I expect this is not a problem with the mikes, but more a problem with gain structure. 'Gain structure' may not mean much to you now (forgive me if I'm wrong, I really have no knowledge of your technical prowess and I could be wrong), but it's worth making this topic one of your next steps.