Which Product to Use for Repairing My Drywall
If it was me, I'd cut away the bad drywall and replace it with 1/2" hardi board. That'll give a flat, solid and waterproof substrate for your tiles, in contrast to the beaten up drywall you've got now. 

Oh, and be sure to thoroughly caulk the gap between the drywall and the hardi.