Dundee as a University is incredibly good for dentistry and ok for everything else, including medicine. I live in St Andrews and visit Dundee regularly, it is not a place I would want to go to university, not just because it's 10 miles from home, but because the city is just like Glasgow, without any of it's good points. In terms of nightlife there are two good clubs, a few smallish music venues and that's about it. I can't sy I've ever been to Leeds, but if I had to choose between the two, based on what I've heard, it would be 100% Leeds.