I made this for my Tevo Tornado which uses 24v fans; one has the original stock Tevo Hotend which is working, the other has my MicroSwiss hot end which I still need to solder the fans to. I printed in Black and Yellow PETG with my Ender 3 and they seem very strong. I have used 3 pins on the plug for the fan, having 24v+ commoned up and the negatives split for each fan; see rough edit of OP's wiring schematic.
I intend to have a seperate +12v from a buck connector in parallel with the part fan negative supply, so I can control a 12v laser using the Fans PWM. I have not yet incorporated the BL touch into the same plug as this is easy to unplug via the header as is.
15way D Sub connectors were sourced from Farnell UK -