I play 9-46 or 9-48 for E-standard and with the occasional Drop-D. 10-50 or 11-52 for D-standard, Open-G/D (Keef tuning) or the (extremely rare) Drop-C. I like the light top, heavier bottom. Been playing that way for 30 years, so it's too late to change now.
You will feel the difference, especially on the lighter strings. Note you may need a minor setup change - truss rod, bridge height and intonation. Nothing serious... just be aware and don't hate the strings if the action feels slightly higher.
In terms of tone? Don't sweat it too much. Hendrix played 10-38. Gilmour plays 10-48. Billy Gibbons plays 7-38. SRV played 13-52. Your fingers are more important than the string guage.
Edit: Here's a list...
https://www.jeffperrinmusic.com/blog/string-gauges-of-50-legendary-guitar-players/
Last edited: Nov 29, 2020