You can do really crazy stuff with them once you get a destabilizer sparrow. I’ve been able to mess around with the hang to the side emotes while doing a barrel roll and it looks sweet
I only have 1 Sparrow with that perk. And it's super ugly.
Good news is they’re supposedly doing a best of year 2 engram, so you should be able to earn some pretty cool looking ones with it even if you don’t want to purchase season 8 ones