Whether you should avoid a DSG or not depends upon the weight you give to the comments of those who have have problems. Some 7 speed DSG gearboxes have indeed given trouble. However, there are literally millions of them out there working perfectly... and bringing delightful driving experiences to their owners.
My 2015 1.2 TSi, which has now covered about 45,000 miles in its six and a half years, is running beautifully, and I wouldn't go back to a manual at any price. But I did have a problem with it in its first year, when gear changes were sometimes accompanied by a chirrupy noise; this was remedied by replacement of the clutch pack under warranty, since which it has given perfect service.
The only way you will get one of the wet clutch versions (which have fewer reported issues) is to go diesel, but in my view that opens a far bigger can of worms, as the diesels have their own set of issues not related to the transmission. I have no data to back this up, but I get the impression that I see far more issues with problems relating to diesel emission systems than I do to dry clutch DSGs.
There is a very vocal anti-DSG lobby; but you must remember that people who are happy with their DSGs (who are the overwhelming majority of those who own them), never write in to complain, whereas nearly everybody with a problem does write in.