Impact of high energy high intensity proton beams on targets: Case studies for Super Proton Synchrotron and Large Hadron Collider