The Arcade VGA will allow you to display Windows on a TV through RGB SCART, so it will be able to play most PC games as long as they don't insist on running in a resolution above 640x480.
It will in no way prevent the TV from showing normal TV programmes. If you want to watch TV through the PC you will of course need a TV card of some description.