If money isn't an obstacle, nothing beats the real thing.
A fine instrument, played well, mic'd well, in a great sounding room... will sound better than any sample library.
The same is true with real physical space. A great sounding (real) room can do wonders when added to an instrument (especially drum kit).
As has been mentioned, knowledge/experience trumps gear.
A great engineer can take decent/good gear and produce great results.
A novice can take world-class gear (top to bottom)... and produce poor/mediocre results.
It's always been best recording practice to get the sound "right" up front (when mic'ing/recording).
No post processing technique or gear will trump this.
I think it's all too easy to obsess over certain detail/s... while forgetting about the bigger picture.
I've known a couple folks who were absolutely obsessive about recording at higher sample-rates.
"No professional would record at 44.1k."
These folks weren't professionals... and they never finished/released anything of a commercial nature.
IMO, They got bogged down in details... to the point where their creativity was stifled.
Much more important than sample-rates, ITB vs. OTB, hardware vs. software, name-brand mics, etc:
The SONG, performance, and arrangement
I love great gear (hardware and software) as much as anyone (ask my wife
)... but if you don't have a great song, the gear is meaningless. After the song, the arrangement is also important.
A common novice mistake is to pile up mid-range (piano, guitar, keyboards, etc) making it extremely difficult to mix.
Closely related: Feel, energy, that "X-factor" trump absolute perfection.
Music history is full of examples of this.
I obsess over gear too...
In the end, you have to balance that with always keeping an eye on the end-goal.
It really isn't about the gear itself... but rather what you do with it.
When listening to the final result, no one (except audio engineers) cares about the sample-rate, the brand of instruments/mics/preamps/EQ/Dynamics, or more generally the gear used to record/produce it.
Great song, great performance, great arrangement is what it's all about.
The end listener will either like the final result... or not. Kind of brutal to think of it that way.
A great sounding drum track, acoustic guitar track, vocal track, etc can enhance the song/performance/arrangement.
But a beautiful acoustic guitar recording won't (in and of itself) give the tune a strong/catchy hook.
If you've got beautiful individual recordings of guitar, piano, synths, and backing vocals... where they're not arranged well together (frequencies are conflicting/masking one another), you've got a nice sounding "beautiful mess".
Did I mention I love gear?