My advice would be to skip buying the SNES entirely, and instead get a more modern console that can support your SNES cartridges. Here is an example of one that I own and use: The Retron 5
The Retron 5
- Plays most, if not all the SNES games you have
- Outputs through HDMI (easily converted to DVI or VGA if need be - for example, this HDMI to VGA adapter, or have a look on Ebay )
- Supports save states and other functionality.
Plus, the Retron 5 also plays game carts other than the SNES - such as the NES, Sega Genesis (Mega Drive), Game Boy/GBC/GBA, and the Japanese Famicom and Super Famicom (basically the Japanese NES and SNES, but they have different cartridge widths). I wrote more about the pros and cons of the Retron 5 on this post.
There are other retro consoles out there as well: Hyperkin also offer the older model Retron 2 (NES/SNES) and the Retron 3 (NES/SNES/Genesis), however from what I've been able to gather they use either S-Video or AV output, not HDMI. If you choose one of these options, you can get an AV to VGA adapter quite easily as well.
There are also ones such as AT Games' Retro Consoles, but I haven't tested them thus I can't speak for their quality.
You mention that you already have some of the consoles that the Retron 5 supports, thus you may be able to look at one of these cheaper options instead for your SNES gaming.
Note: I am not affiliated with Hyperkin or the Retron 5, I just use one and it's pretty great