39 cards where the name includes “the” and the name includes “hero”

Butcher of the Horde (Khans of Tarkir #168)
Chained to the Rocks (Theros #4)
Crovax, Ascendant Hero (Time Spiral Remastered #15)
Drag to the Roots (Duskmourn: House of Horror #213)
Elesh Norn, Mother of Machines (Phyrexia: All Will Be One #10)
Feather of Flight (Bloomburrow #13)
Fork in the Road (Shadows over Innistrad #205)
Gerrard, Weatherlight Hero (Commander 2019 #41)
Grip of the Roil (Oath of the Gatewatch #56)
Hazel of the Rootbloom (Bloomburrow Commander #2)
Heroes of the Revel (Theros Beyond Death #138)
Hero of the Dunes (The Brothers' War #213)
Hero of the Games (Double Masters 2022 #112)
Hero of the Nyxborn (Theros Beyond Death #219)
Hero of the Pride (Theros Beyond Death #22)
Hero of the Winds (Theros Beyond Death #23)
Into the Roil (Foundations #509)
Invasion of Theros // Ephara, Ever-Sheltering (March of the Machine #23)
Invasion of Theros // Ephara, Ever-Sheltering (March of the Machine #23)
Kytheon, Hero of Akros // Gideon, Battle-Forged (Magic Origins #23)
Kytheon, Hero of Akros // Gideon, Battle-Forged (Magic Origins #23)
Lin Sivvi, Defiant Hero (Nemesis #12)
Mother of Goons (Unhinged #59)
Mother of Runes (Commander Legends: Battle for Baldur's Gate #702)
Omnath, Locus of the Roil (Core Set 2020 #216)
Preacher of the Schism (The Lost Caverns of Ixalan #113)
Rimefeather Owl (Coldsnap #42)
Rush the Room (The Lord of the Rings: Tales of Middle-earth #147)
Sakiko, Mother of Summer (Commander Masters #319)
Shaun, Father of Synths (Fallout #119)
Soul of Theros (Magic 2015 #34)
Tenth District Hero (Murders at Karlov Manor #34)
The Rollercrusher Ride (Duskmourn: House of Horror #155)
The Royal Scions (Throne of Eldraine #199)
Usher of the Fallen (Kaldheim #35)
Valentin, Dean of the Vein // Lisette, Dean of the Root (Strixhaven: School of Mages #161)
Valentin, Dean of the Vein // Lisette, Dean of the Root (Strixhaven: School of Mages #161)
Vanguard of the Rose (The Lost Caverns of Ixalan #42)
Watcher of the Roost (Khans of Tarkir #30)
Watcher of the Spheres (Core Set 2021 #227)
Wilhelt, the Rotcleaver (Midnight Hunt Commander #2)
You're Ambushed on the Road (Adventures in the Forgotten Realms #43)

Though this query has ended, its relics still slumber in New Argive.