This has nothing to do with modelers, frfr speskers, home vs gig volume eat al, honestly. It’s simply a continuation of the age old issue of solo vs band mix.
Guitarist have always had issues of dialing in their rig solo, getting that ideal tone, and then disappearing in the mix. Or, hating the isolated guitar tone in the studio, only to then think it sounds great in the bad context.
Anyone who’s ever played a Big Muff in their bedroom thinking it sounds great, but then that he audience hardly could even tell they were playing guitar at a live gig, can relate to this all too well.
As was suggested earlier, listen to some isolated guitar tracks of favorite albums for context and reference.
Who doesn’t love Slash’s appetite tone right? Many chase it as the ideal hard rock Les Paul/Marshall tone, but ever listen to those tracks in isolation?
It’s so thin and bright sounding that many would use terms like “awful” and “garbage” or from a $99 mfx pedal.
Add in a second guitar, bass, drums etc though and it sits perfectly, cuts well, and the overall tone is a hard rock classic many put on the pedestal as the iconic tone.
Funny how that all works out.....