This Sorcerer subclass is designed to cover a niche the Sorcerer was unable to fill: a melee full caster similar to the Hexblade (Warlock) and Bladesinger (Wizard). Both of these subclasses tend to be quite popular among the playerbase, as they cater to a very distinct theme and playstyle.
While filling a similar role, a big emphasis was that it still plays in a unique way. Its intended playstyle is to combo multiple magical effects into a single attack.
The Right Needle for the Job gives this subclass everything it needs to function while Weave Magic is the core subclass mechanic. Combining a spell into a weapon attack is a unique mechanic in D&D 5e so this was a challenge to design and keep balanced.
Extra Attack is a staple for martial type characters.
Threading the Needle gives this subclass a unique option for movement, as is often seen with sorcerer subclass features for 14th level.
Unravel is the big, costly, all-out attack. It should create an awesome imagery and feel powerful to use. However, it drains a lot of Sorcery Points, so it is an important decision on when and how to use it.
Shifters first appeared in the playtest material Wayfinder's Guide to Ebberon and later got released in the official Sourcebook Ebberon: Rising from the Last War. Their defining feature is the ability to "shift" into a more animalistic form.
However, any type of winged Shifters are missing. This sparked the idea for this subrace. The structure for Shifter subraces follows a fairly strict theme, which I also used for the Stormwing.
Ability Score Increase:
An increase in Dexterity and Wisdom fits the theme of flying, predatory hunters.
Keen Senses:
Be it the eyes of predatory birds or the sonic abilities of bats, airborne hunters tend to have some well developed perception mechanism, thus this choice was obvious.
Shifting Feature:
Stormwings flying works slightly different than Aarakocra. They are slower in the air they can use this feature and still wear medium armor, while Aarakocra is restricted to light armor. Additionally of course it is limited by the Shifting Feature itself.