SPECTRE-GHOST: Spectroscopically Probing Extremely hot Climates of TRansiting Exoplanets with GHOST