2312 by Kim Stanley Robinson features the idea heavily (the main character is a former "asteroid terrarium designer"). The Expanse series has quite a bit of it too.
Came here to recommend 2312 & the Expanse as well! Any other content in this genre you enjoy/would recommend? I'm looking for my "next"
You might like Alastair Reynolds’ earlier works too. His short story collections are a good place to start (Zima Blue, Diamond Dogs).
Stephen Baxter's Phase Space. If those short stories, especially the ones with Reid Malenfant, grab you, then read the Manifold series. If you find yourself wishing it was more Alastair Reynolds, then the Xeelee Sequence.