Can you point to a single game that utilizes this mode? I am pretty sure there are none.
Its only practical use is for video titling software, some of which I know supported the mode.
Virtual Karting and Virtual Karting II use super hires in a pretty elaborate way, akin to how LCD screens work with red, green and blue subpixels.
AGA also outputs at 35ns pixel resolution (super hires) at all times regardless of what the screen resolution is, and games running on AGA can benefit from this for free by adjusting the position of hardware sprites and hardware-scrolled screens with super hires accuracy.
I don't know how modern LCD screens handle these things, but on CRT screens these narrow pixels and differences usually blend together but still give a perceived increase in image quality.