About 90 minutes tops personally, I enjoy the drive if there are no jams, I sit in a comfy (heated) seat in a climate controlled room with a great sound system, but I want to be able to drive normally/quickish, I get highly annoyed in jams, too much stress.
Trains are fine too for up to 90 minutes, though not all, just the ones with wifi and when I have a place to sit.
I wouldn't do it if it involved sitting in a subway train for longer than 45 minutes, or in a bus.
So 90 mins tops train, car (outside rush hours).
45 minutes tops bus/subway/trams.
30 mins tops by moped or cyling.
20 mins tops walking.
But no longer than 90 mins total, preferably all in the car.
Also depends on the pay of course, if travel costs more than an alternative job close by, then obviously no...
Why so long in cars/trains ? I enjoy travel by both of them, in the train it's comfy and wifi means just browse the net unlimited or watch something online. Car travel is always enjoyable, wakes me up and makes me feel good, provided I can keep moving. Once I get in a jam I start getting highly annoyed and driving gets tiring and annoying ( especially because I try to get out of it asap, look for alternative routes, switching lanes all the time to the one that is moving, etc.).