So, finally after a long time and with a few failed purchases I got the right stuff together.
Quoting Wikipedia about tripod thread standards:
Screw thread
Per ISO 1222:2010,[1] the current tripod screw thread standard for attaching the camera calls for a 1/4-20 UNC[2] or 3/8-16 UNC thread.[3] Most consumer cameras are fitted with 1/4-20 UNC threads. Larger, professional cameras and lenses may be fitted with 3/8-16 UNC threads, plus a removable 1/4-20 UNC adapter, allowing them to be mounted on a tripod using either standard.
Historically, The Royal Photographic Society recommended the thread standard for attaching older cameras to tripods was 3/16-24 BSW (3/16 inch nominal diameter, 24 threads per inch), or 1/4-20 BSW[4] for smaller cameras and 3/8-16 BSW[5] for larger cameras and pan/tilt heads. In this application, the BSW and UNC thread profiles are similar enough that one can mount a modern camera on a legacy tripod and vice versa. The UNC threads are a 60-degree angle and flattened, whereas the BSW are a 55-degree angle and rounded crest. However, at least one English manufacturer uses No.1 B.A. (British Association) for its tripod mount thread.
When deciding for the brand, I went with German manufacturer Völkel which are producing industrial quality threading tools.
As there are lots and lots of different tool combinations to choose from, I'm putting up the exact item numbers you need to buy for anyone in the same situation like me. All tools are high quality made from HSS steel. You also should use universal cutting oil, just in case.
For 1/4 UNC:Hand tap set, ≈ DIN 352, HSS-G, UNC 1/4 x 20 (item # VOE23314)
Round Dies, DIN 223 (DIN EN 22568), HSS-G, UNC 1/4 x 20 (item # VOE23414)
Die Stocks, Zinc die cast (mm) DIN 225 (DIN EN 22568) Size 20 x 7 (item # VOE15003)
For 3/8 UNC:Hand tap set, ≈ DIN 352, HSS-G, UNC 3/8 x 16 (item # VOE23318)
Round Dies, DIN 223 (DIN EN 22568), HSS-G, UNC 3/8 x 16 (item # VOE23418)
Die Stocks, Zinc die cast (mm) DIN 225 (DIN EN 22568) Size 30 x 11 (item # VOE15005)
One for both tap sets:Adjustable Tap Wrenches DIN 1814 Size 1 (item # VOE13010)
Thread repair sets:Thread Repair Kits, UNC 1/4 - 1,5D (item # VOE04107)
Thread Repair Kits, UNC 3/8 - 1,5D (item # VOE04109)