Aye, there're no Silent Hill games on PS4/XB1 except for PT -- and we all know what happened to that. 😞 There are a few options on PS3 and XB360, though. Firstly, there's Silent Hill: Homecoming, which is a very underrated SH title. It's not quite as amazing as the first Japanese-developed games, but it still has a great story, creepy atmosphere, fantastic score, cool monster designs, and a decent combat system. I really liked it a lot.
Next, we have Silent Hill: Downpour. It's decent, but not quite as good as Homecoming imho. Still, it's a solid entry with a pretty well-written story. Enemy designs aren't that great, though. Also, Akira Yamaoka - who wrote the iconic soundtracks to the previous SH games - is absent in this game, which is a shame.
Then, you have the Silent Hill HD Collection - which bundles together fan favourites 2 and 3 - but it released in a terrible state. It's since been patched, but it's still pretty buggy. They're playable, but aren't the ideal way to play those classics.
You can probably pick all of them up for cheap pre-owned.
Hope that helps!