There is a great series on YouTube from Jim Lill about "where does guitar tone come from".
He investigates what makes good sustain, what makes good strings, what makes a good amount, what makes a good cab, what scale lengths do to tone, etc.
My big takeaway was that your EQ and production matter way more than any equipment your using, as long as it's all in tune and all that
Heres a quintessential video for the pursuit of tone: https://youtu.be/y8GiF-GVLgg