Turning "one trick pony" guitars into the "one guitar does it all" approach is something that has been attempted exponentially for many decades now.
The only thing even remotely close to accomplishing this is the Variax James Tyler guitars.
No guitar comprised of purely traditional guitar partes (ie; no modelling technology) can come as close.
You can achieve a wide variety of useful tones in a multiplicity of applications, but you are still limited to subjective ingredients, ie; Solid body vs Hollow body, high output pickus vs low output pickups, true single coils vs stacked single coils, scale length, string gauge, and we haven't even gotten into amp selection and tone stack setup.
Heck, even my "5 pickup Strat" idea, as flexible as it may seem, is still limited in comparison to the imaginable possibilities of available electric guitar sounds.
Ideally, it does take a plethora of guitars to achieve truly a authentic plethora of guitar sounds, and more often than not, you'll find a smaller number of those options that truly work for your given guitar tone proclivities.
Best counsel I can advise, pick the most commonly used tones that you use consistently, exploit those options, and maybe a few more "occasional" option to service the rare exceptions.