For thick and normal hair any oil or butter is fine. In my "Adore Me" DIY whipped hair butter for thin hair I use two exotic butters cupuacu/kukui and murumuru as they are both very light. However, those are not the only light oils on the market.
Personally, I have very dry hair (& skin) so I am not a very big fan of the less greasy oils, I like some greasiness.
I HATE the smell of Macadamia, the taste, pretty much anything and everything to do with Macadamia nuts - don't know why so you will never find me using it.
Light feeling oils and butters
Medium to heavy oils and butters
If you have shea butter just reduce its quantity in a whipped butter and add more oil to make a creamier blend which is better suited to fine strands. As for cocoa butter, it is much heavier and harder so if you have thin hair I wouldn't use more than 15% in a whipped butter and even less in other DIY products.
You might also like:
Ref: SwiftCraftMonkey (Grapeseed) (Oil Guide), EatByDate (How Long Does Oil Last), GardenOfWisdom (Shelf Life Of Oils)