VARCHAR missing index not showing up in missing index dmv or query plan suggestions
Almost certainly because it is seen as a trivial plan and those do not activate the missing index feature, there´s a workaround in this blog by Mr Darling
https://www.erikdarlingdata.com/sql-server/whats-the-point-of-1-select-1/