Yes! Humanity has been out among the stars for a thousand years; so I think derelict, abandoned and incomplete stations should be as common throughout the bubble as ruined castles are today in somewhere like Scotland.
They could be a new source of specific gameplay types (like OP describes: stealth missions involving sneaking down corridors in a Sidewinder, etc.), but even if not, IMO they don't need to have a huge amount of programming work put into them to be interesting, they would just need art assets for dilapidation and chunks having been stripped away by meteors and scrap metal thieves. Even if they are just something like the installations we already have, that would be great. Use them as rendezvous points for missions, maybe some have pirates hanging out at them, let us fly though them, and fight in and around them. Maybe materials spawn around them as they break apart, or let us use mining lasers to bust materials free of the hull as a form of salvage activity. Make them completely dark inside so that we have to use our ship's lights to see what we're doing. It would be atmospheric and very, very cool, for what I imagine (in my inexpert imagination) to be a reasonably small amount of effort, based on existing assets and AI.