The hero known for his tragic destiny involving the city of Thebes is Oedipus. In Greek mythology, Oedipus unwittingly fulfills a prophecy that he would kill his father and marry his mother, leading to catastrophic consequences for himself and the city.