Another thing to add to the "pro" column for the diesel is that GM doubles the powertrain warranty on it.
The biggest "con" is having to deal with DEF. The main issue with DEF seems to be using a lot when towing, but I am at 5K miles in our Yukon and DEF was at 50% with no towing. 2.5 gal every 5K miles doesn't seem too bad. Seems to be a good idea to fill it up at 50% since the range calculation used for it can think it's low when it really isn't yet. Another con would be the diesel has a fuel filter that needs to be changed (recommended at 20K miles, but best to do it every 10K). Dealer quoted me $260 to change it, but i will do it myself since the part is $30 and easily accessible.
When we were test driving yukons and XL's you really couldn't tell a difference in the 5.3 vs diesel unless you know what to look/listen for. I know some will shy away from them since they expect them to sound like a big work truck, but they really don't.