Can anyone point me in the right direction in regards to TV tuners which have the right inputs for connecting consoles?

Basically, I intend on building a display wall ( to use for various things such as monitoring cameras and the network etc. ) and would like to plug the game consoles I have into the computer to display them on it as well. If not, it'd still be useful to be able to play on consoles while sat at my PC