im from Dundee originally and still have family there so regulary visit. Lots of affordable housing options, and very quick access to the country, biking, hill walking, climbing, skiing, good sailing scene. Traffic not too bad either. big university scene in west end, plenty commuter options if you wish. Changed huge amount for the better in last 20 years. I would recommend it for a dream job opportunity without hesitation. There are large areas in the city you dont want to live, but thats the case anywhere in the UK.