I own a fl Cupra and love the manual gearbox, however, since taking a scirocco R DSG out, I've pined for one ever since. In my opinion, the gearbox is sublime and a masterpiece. I would have it over a manual in a heart beat, but the Cupra didn't come with that option in the model.
As mentioned already above, you're going to get many different responses to your question. It's purely down to you. Most of my driving is motorway and usually only at weekends, but as there are so many b4stard speed bumps everywhere and congestion, it's a ball ache to be continually up and down on the clutch.