I still have a VCR but I almost never buy tapes anymore. There's not that much that's still on VHS but not yet on DVD or Blu-ray (or streaming).
If you hunt enough you'll be surprised what you find :)
Just check out these two links from a quick Google search:
https://www.imdb.com/list/ls000028642/https://bandsaboutmovies.com/2019/06/28/ten-movies-that-were-never-even-released-on-dvd/As I said this was a quick Google search that literally took me less than 10 seconds. I'm sure a bunch of these have since made their way to DVD. I know Song of the South for instance has made its way to some bootleg release (and also helped ignited a pretty severe argument on this very forum recently haha).
VHS tapes are a little similar to vinyl. All the really good stuff has made its way to more recent formats A LONG time ago. However, as these were both dominant formats for 10+ years it stands to reason that there is a ton of crap people never saw any reason to transfer over.
As for me I have enough crap readily available on DVD and streaming that I'll probably never get around to watching. So my desire to hunt for obscure VHS crap isn't that intense.
The only thing that really sticks out is the original VHS version of I Was a Zombie for the FBI. That film actually did make it to DVD, but in a severely different form. George Lucas would wince at the alterations made to that film. For those who don't know when the DVD was released in the 2000s the director re-shot about half the film with significant changes. He then took out the old half and mixed the new stuff and old stuff together. It would be different if the DVD did the easy thing of releasing both versions. But only the new edit was released with a completely different soundtrack and literally half the original film missing.