Recommendations Crafting/Crafts/Pill-Refining/Crafts Skill-Builder/Crafting VR/Farming/Utilizing lost knowledge

Ancient Strengthening Technique already fulfills your pill-refining and utilizing lost knowledge requests. His lost knowledge also encompasses a lot of things that are unlocked gradually so he has all sorts of crafts as well, some unlocked but much more still locked. So you could wait a little longer until he unlocks more before reading but I think you should definitely keep an eye on it.

 

read this up to drunken fragrance fruit and then it just... I don't know. I don't find the progression to be good ahow he changes his mind from having one wife sternly which I hope he would've done but then he moved on like the pervert I expected him to be. I do like the fact that his cooking and ingredients can only be made by him

 

Here are some novels with the crafting or knowledge area that's focused on.
Cook of the Mercenary Corp (cook)
Risou no Himo Seikatsu (Earth knowledge)
Genjitsushugisha no Oukokukaizouki (civil administration/nation building knowledge)
The New Gate (blacksmith)
Knights & Magic (mecha otaku wanting to build a RL mecha)
Parallel World Pharmacy (pharmacist)
Common Sense of a Duke’s Daughter (accounting)
The Other World Dining Hall (LN) (cook)
Seiun wo Kakeru (blacksmith)
Takarakuji de 40-oku Atattandakedo Isekai ni Ijuu Suru (Earth knowledge/items)

 

Most if not all of these have been mentioned already. I'll take a look into them though

 

You might like the subjugation series by fel. This is an adult series and you'll need to download the chapters. Stories have been being updated slowly though.
https://forums.sennadar.com/viewforum.php?f=24
Main character starts out as a student learning alien tech on a recently subjugated earth. Aliens are telepathic so humanity can't fight back but he ends up inventing and building many things (rail gun). It moves away from the building for the most part later in the series (moves to management).

 

Myth Online: http://royalroadl.com/fiction/3322 maybe, only a little bit of crafting
Seeker of Myths: http://royalroadl.com/fiction/383

 

legendary master wife(bl) The Lord is Addicted in Infrastructure(bl) . Superstar From Age 0 This Game Is Too Realistic . The Healer Demands Payment!I. Love Farming(bl) I Have Medicine.(pill making is literally a main focus of the novel at least until 300+ chapter bl. )Number One Lazy Merchant of the Beast World(bl). I Wanted To Enjoy a Slow Life While Exploring the Territory With a Secret Gift [Craft Skill], but I Was Intentionally Banished to the Frontier by Pretending To Be Incompetent .Witch Hand Craft.