You can play with or against others any time of the day with any kind of game you want no matter what your physical condition. There are social games as well as antisocial ones, roleplaying games as well as action games, really any kind of game anyone could want. However, the beginner may find the barriers to entry prohibitive. Most hardcore PC gamers have been playing their entire lives so are accustomed to the technical details necessary to start playing.
Consoles lack the power, high speed bandwidth, and control options of PCs.
While you do need to know a bit about networking to start playing, it's not as complex as it may sound to the uninitiated.