Best footwear?

As others have said, depends on the type of work you’ll be doing.

There’s a huge difference in weight and comfort between a cheap pair from a builder’s merchants that are steel toed and steel shanked and a pair of composite toes with no shank. Each company’s idea of waterproof can vary a lot too.

If you’ll be outside a lot in snow/ice/deep puddles, steel toecaps can conduct the cold to your feet if that bothers you.

I personally like Timberland Pros as I have wide feet and some of their range are incredibly light weight.
I’ve found Wolverine comfy in the past but a bit narrow - They come with a 30 day comfort guarantee if you’re not happy with them.
I’ve heard good things about Uvex safety trainers but never tried them myself.
Last 2 are available from Arco.