one option to spice up mining entertainment, could be shifting some of the focus from actually extracting the resources, to surveying for a good mining site. have resource richness shift through the world, forcing you to sometime go out into some pretty remote areas to mine the resources. where as most games just have you shoot a laser at a asteroid, you could have more than one type of gameplay for the process. ex. finding the resources, getting there, extracting them. as opposed to just going and extracting
star wars galaxy had an interesting system where resources shifted, one week you may have a rich resource site right near town. then next week you may end up having to go explore deep in the outskirts to find a rich resource site. the actual mining was done through an automated harvester, however the shifting resources made it entertaining, as it involved exploring, and going out on a survey expedition. the richer the site, the more you gained mining it. the nice part is it was dynamic, so you could just look up a wiki or guide for the best place to mine.
it would be neat to put together a small survey/mining fleet with escorts to go explore and look for a good place to build a mining outpost
something similar could be adapted upon here, especially due to asteroids moving through space, people wouldn't question it