yesterday I visited several electronic discounters and verified the available connectors and tv set models.
To my surprise all current (half year old TV sets or newer) have a YPbPr connector which is described as color difference connector for analog HD connectivity. This connector is implemented as 5 cinch connectors and seems to be the opposite to HDMI but with analogue signals.
Beside that the standard connectors are:
up to 5 HDMI connectors
up to 4 USB connectors
only one SCART adapter which is clearly outlined as AV/RGB signal
one TV HF connector
some highend products also offers RGB cinch connectors. The newer one only offers SCART via additional adaptor (looks like a PCMCIA cable connector).
All vendors starting from Sony, Samsung to Panasonic or Loewe, Phillips offers similar connectors. None of them offer S-Video at all on newer models. According to the wiki page S-Video is not within the SCART standard definition and an add-on solution in the past. You are not able having a SCART Adapter with S-Video AND RGB at the same time. AV is the fallback solution despite if the SCART connector has S-Video or RGB. On older models with two SCART connectors one is with S-Video the other with RGB. Some rare models offers the possibility to turn S-Video on and RGB off. This is also outlined on WIKI pages.
From the current technical sheets of HDMI video prozessors RGB and AV is available on all of them. But S-Video itself is not included and must be implemented in an additional circuit. May be that's the reason it is now obsolete as this costs extra money and the video prozessors or filters available for S-Video are all marked as "do not use for new product designs". Have a look to current datasheets available on different sources or vendor pages.
So in summary not one offering within eBay - despite those having an AV to SCART adapter included - allow to connect a modded retro console directly to current TV sets. Not sure why YPbPr cinch connectors are the only method to connect analog devices now instead of a combination with AV/RGB/S-Video connectors.
I ask people if there are S-Video still around but only a few beamers are available offering this signal connectors. Searching on discounter websites also provides only beamers. There are some old tv sets still in stock offering this mode but don't believe it will be available forever. Specially as TV sets today are designed to run for max 5 years, Samsung devices most likely die within 3 years according to statistics due to weak parts. So finally you may extend the lifecycle of the product by repairs but finally most components (specially the video processor units) will be stopped in production after a few years due to fast development cycles so getting spare parts will be a problem sooner or later.
So in longterm the only chance to connect your beloved console is currently AV, RGB or HDMI. Last one requires to be part of the HDMI consortium which requires about $10.000/year to officially use it (the HDMI decryption crack is illegal). Another possibility would be to use converters but the results today are worse if the console output is below 800x600 pixels. there are a few professional converters out there but the price tag is quite high.
Sure we can use tubes or old TV sets but this is not a longterm solution. No one I know accepts small screens or missing key features like 3D, 4K or missing HDMI connectors. Because you most likely own one full featured TV or beamer with stereo/surround system, backlight, balanced loudspeaker system etc. So why using a bad old TV set for game playing using a lot of space and looks ugly in comparison to the electronic monster next door with 50" or higher?
So current assumption there are plenty of old TV's available is true in USA (until important parts are broken because these are produced in china and will be stopped if there is no high-volume demand anymore) but this argument fails completely in europe.
The difference in cultures may be that in europe space and resources are limited, we all want the newest and hottest stuff available for that reason, less energy consumption is good, if there is a damage we replace the device as repair costs more than a brand new device. So we dumped all tubes years ago and all repair shop closed their business as we only buy on electronic discounters which offers only the latest and greatest coming from china. I know in america there seems no limitations as government protect or better pays compensation to lower resource costs as increasing prices leads to trouble and questions. If you are interested in economic numbers you will notice the USA pays more and more for the resources as china pays the highest prices and requires a big chunk of all worldwide resources for their economy. So USA will loose finally on the market if they continue this modell of compensation as their own resources are running low.
So as development resources are limited in retro area and there is no interest due to all this rule violations which prevents competition for official products the only chance is to arrange with current connector offerings and kissing obsolete ones goodbye. You may extend the lifecycle of your current products for a while but this makes any switch later quite harder. Remember all these "standard" connectors in PC world which were a pain if not adopted quickly.