Too bad X4 Foundations checks all the boxes, except multi-player. You can drive almost anything in that game from little fighter, to miner, to corvette, destroyer, and other capital style ships. You can jump from cockpit to cockpit of ships you own etc. The problem though is that you have to earn enough credits to buy these ships. You just don't get them. That means doing missions, or mining, or other forms of generating credits until you can buy something to help. The game gives you lots of pathways to gaining those credits though, should you decided to try it.