I've never seen or used S-VHS.
I still have and use my Panasonic PV-4022 VHS VCR, but I use it mainly to view old VHS tapes I recorded from cable TV years ago (I have a rack full of such tapes, about 40+ at last count, in my bedroom). The deck is set up and hooked up to record off the air, but I don't use that function often anymore since I can get streaming video and podcasts online just about any time.
The VCR doesn't get much use these days, however, since I have a Blu-ray player and a growing collection of DVDs, mostly '60s-'70s TV series. I am finding that most of the shows I have on VHS are and have been available on DVD for some time, so I guess my VHS VCR will get less and less use as time goes on. I can even see a day coming when I may put my VCR in storage indefinitely.
Standalone DVD/VHS players without RF tuners are available, if all you are interested in is watching old VHS tapes and DVDs. As long as my VCR still works, however, I won't get one of those combo units, as I have heard and read that they are made to last only a very short time, then something wears out or breaks and the thing is junk from that point on--like most everything else these days.
Sheeesh.
DVD/VHS players from makers such as Funai are among the worst, from what I have read. These players are often branded Magnavox, but don't let that name fool you. I had a Magnavox-branded VCR that lasted only about five years, then the heads (and, if I remember correctly, the transport mechanism) wore out. I bet that VCR was manufactured by Funai.