I'd merge the Hexblade and Ravenqueen subclasses, if the Raven Queen is connected to these blades, then you don't need a seperate patron for her. Just replace the shadow hound with the raven and maybe one other feature with the ability to merge with it.
The Lore Wizard, wow can you say over powered much!
I mean I do like that they gave the generalist wizard a unique flavour so that its not boring, so A+ on flavour, but the features need to be toned down, they should not have an ability that is straight up better then the distant spell metamagic.
And the elemental damage change should be be restricted to once a short rest and/or require a spell slot to power. In fact almost every feature of the class needed to be toned done except for the lore expertise which fits the themes of the class to a tee, your that scholar's scholar, the sage's sage.
I have mixed feelings about the patron features, I'd be more open to having this prequiste if there were far more general invocations, so I'd keep it to a minium. And tone down the patron pact weapons abit, you don't need to out shine the Paladin's smite. Even the Stone Sorceror doesn't do that.
I personally liked the previous sorceror subclass UA better honestly, I was suprised at having no Shi'ar wizard which was disappointing to me.
And as I said merge Hexblade and Raven Queen Patrons to make space for another patron like Slaadi Lord, Primus and high powered and rogue Modrons, Celestial Pact (Angels, Kirin, Unicorns, Coutls, Archons, Celestial Elderin, ect...), Beast Lord Pact (like the Cat Lord, Bear Lord, ect...), Pain Patron (Lady of Pain, Dabos, and simular entities pact).
And for Pact news perhaps a tattoo back, you gain a magic tattoo that can hold a first level spell that you unleash by touching it, short rest at first, then at will at higher levels.
Aura Boon, those enemies who are in your aura, 30 feet at first the. 60 feet at level 18, take disvantage on their saves, perhaps with a charisma saving throw to aviod the effect.
Maybe turn the shadow hound into a pact boon, you get a shadow hound as boon, but fluff wise it reflects your patron, so if you a have Hysam your hound might have Satyr horns and a fey look with glowing Elven Runes over its body, a shadow hound of Acamar might have tentacles instead of legs and a look of alien madness in doggy eyes, a Undying Hound of Gilgamesh might have his holy symbol on its forehead and be shaped like a popular Untheric breed of dog, and have a very dominating presence.