I just finished the game a week ago and it was a nice experience. The story and the characters were completely forgettable and uninteresting but the art style and exploration vibe were great. I too 100% it and the game didn’t overstay its welcome. Just a nice casual exploration.
This week I started Tchia which has similar exploration feeling in New Caledonia but lots of Ubisoft style collectables and minigames. So far so good.
I love engineering games like that but I don’t believe any game will check all the boxes you want.
Like others here I vouch for Satisfactory Trucks and especially the Railways. You can go quite deep there if you want. Drones do the clipping and are bit too easy so skip them.
While not what you exactly wished I’d say give Transport Tycoon or rather OpenTTD a go. While not as pedantic with traffic as you hope you will have a blast of a time doing beautifully orchestrated trains, airports, ferries and trucks/busses and optimizing the routes from resources to consumers.
And to reiterate. I don’t believe a game exists that matches most of your wishes. I hope it will eventually!
It has been two years since I did a perfection run on Stardew Valley so why not do it again - this time heavily modded with the most downloaded extended mod pack that I customized even further.
I’ve also tried to play Where Winds Meet but Stardew has my attention nine days out of ten.