>I remember the game magazines had advertistements in the back for VGA adapters for the SNES.

Those adapters have converter chips in them and are a very recent thing. One from your link was released in 2025, a full year after last gaming magazine stopped being printed, and 30 years since last magazine covering SNES shut down.

snes rgb cables on the other hand were always available, and even bundled with console in certain markets.