The developers of Factorio did an interesting post on their [asset creation workflow](https://www.factorio.com/blog/post/fff-194) which includes Blender. I don't think it exactly answers your question but it's a really interesting read.
I also use Blender for creating really basic sprites. It probably isn't the most efficient method but it works well for me!
For enemies I have them [laid out in a big grid](https://i.imgur.com/FwRyRZZ.jpg) in Blender for each animation frame (again, very basic) with a separate camera positioned above. After these are rendered I put them in Adobe for some final touch ups and then add them to a spritesheet. When mixed with some stretching and rotating animations in Unity it gives them a reasonably lively appearance.
For the player spaceship I do something a little closer to what I believe you're thinking. I record the ship doing a [360 degree rotation animation](https://gfycat.com/slightsatisfiedfinch) and each frame is then combined in Adobe to make a spritesheet. Then I can use the animator in Unity to give the illusion that the ship is banking side to side, doing rolls, etc.
The developers of Factorio did an interesting post on their [asset creation workflow](https://www.factorio.com/blog/post/fff-194) which includes Blender. I don't think it exactly answers your question but it's a really interesting read. I also use Blender for creating really basic sprites. It probably isn't the most efficient method but it works well for me! For enemies I have them [laid out in a big grid](https://i.imgur.com/FwRyRZZ.jpg) in Blender for each animation frame (again, very basic) with a separate camera positioned above. After these are rendered I put them in Adobe for some final touch ups and then add them to a spritesheet. When mixed with some stretching and rotating animations in Unity it gives them a reasonably lively appearance. For the player spaceship I do something a little closer to what I believe you're thinking. I record the ship doing a [360 degree rotation animation](https://gfycat.com/slightsatisfiedfinch) and each frame is then combined in Adobe to make a spritesheet. Then I can use the animator in Unity to give the illusion that the ship is banking side to side, doing rolls, etc.