Tried it a few years ago.
It does work.
The feeling of laser sharp focus and high energy is quite pleasant and is clearly helping to work for long hours.
But it ended up with a severe burn-out in my case.
Not 100% sure it was the Modafinil, but retrospectively I think it made me drain my batteries a lot quicker.
My advice, if you need to work a lot, the best nootropic you can get is good sleep, healthy food and a bit of caffeine.