It really is just another another liquid solvent. But, getting a liquid state out of CO2 is not a DIY effort.
The beauty of n-Butane is the boiling point is low, 31.5 F at atmospheric pressure. So, without heavy pressure and low temps we can use a dandy solvent that can be recovered as a gas by heating it to room temp again. Plus it will not freeze solid in vacuum at standard temp (59F) either.
That is not the case with CO2. CO2 extraction does not produce better results. In fact, they have found in paprika extraction, n-butane is better, being easier to control the pressure and temps. The entire paprika industry in Hungary, paprika's home base, is moving away from the heavy cost and dangerous CO2 extraction methods for n-Butane.
I read some really good papers in the literature about it.