Here I will try and update the list of chargers that do (green) and don't work (red). Maybe one day I will get enough data to come closer to a definite answer.

If somebody has any thoughts don't hesitate to add them in the comment section.

With the docking station I tried all works as expected, with a third party power supplies, the ability of the green or orange light turning on is especially favorable when:

You have everything plugged in and reboot. You may notice flickering of the screen during the apple logo. I think this has to do with power negotiation between macbook and magsafe.

You turn off your computer and plug it in. Keep it plugged in with the lid down seems to be the most successful method that requires the least amount of flipping usb, replug or reboot.

Flip the USB C power supply side 180 degree in the female female adaptor.

Docking station always works. Maybe power negotiation chip is always present in those since its made for multiple computers.