If the CSI writers want to make it emotional, the person who finds him needs to be either Nick or Brass. I'm not saying that it wouldn't be emotional if another memeber of the team found him. However, with Nick, you know it will be a teary scene to witness because of how much he loves his friends and family. I truely believe he would do anything for someone he loves. He would be devastated to find his friend like that; plus, this could be what launches him into dealing with being buried alive.
I could also see it being emotional if Brass finds Greg beaten up. Maybe not in a open way like it would be with Nick. Think about it. In season 6 alone, Brass accidentlly killed a follow officer, and was shot himself. Now here he finds this rookie, no this kid, who has never done anything to anybody. This young man who loved to listen to music while he worked, and always had a bright smile for everyone. And now, someone has severly beaten this kid, likely leaving him for dead.