How come there isn't some type of adaptor so that you can use Playstation controllers with computer games.
There is. It's called an adaptoid.
Or, even better- you could simply buy a controller. a lot of USB controllers are styled after the PS2 controller for some reason. (Logitech Dual Action and Rumblepad 2 are the two I have, they look identical to PS2 controllers).
I'm asking because using the keyboard and mouse, I think, is just awkward. ...and I went back to Playstation for gaming.
I find the opposite. I only use my controllers for Emulation (NES,SNES,Genesis, n64, GC, Wii) as well as a few select PC games (GTA3,VC, and SA mostly) I'd love to use it for JC2 but apparently it only supports an Xbox-360 controller for some reason. oh well.
Anyways, Adaptoids, that's what you are after, strictly speaking, for using a PS2 controller on your PC. It makes it into a USB controller, or of course you could just get an Actual USB controller, (since as I noted many of them are modelled after the PS2 controller). You can get adaptoids for nearly any systems controller, NES, SNES, N64, GameCube, Genesis, etc... they can all be hooked up to a PC as a USB controller using an Adaptoid.
Your second question, re: keyboard keys being assigned to controller buttons. First: the FIRST thing you do when you want to use a controller in a game, is change the options of the game so that it uses the controller. Almost all games support the use of USB controller input. Some however do not. There are a LOT of programs that fill this supposedly empty niche, such as Joy2Key. There are still problems with that approach, however. The main one is that analog controls become digital if you have to rely exclusively on the mapping program.