How do i get my game controller to work in a game...

The Games are:

Kingpin: Life of Crime
Red Faction
METAL GEAR SOLID
Beneath a Steel Sky

these are the only one`s i have installed so far

Can you help me please....

the Steam program is great for controller calibrations. Try that.

I don't think Kingpin, Red Faction and Beneath a Steel Sky support controllers.
Though I don't know for sure, mind you.
(I would never play First Person Shooters or Point-and-click-adventures with a controller...but to each their own,
I guess)
Why not look in the games' specific subforums?

https://www.gog.com/forum/metal_gear_series#1639558857

https://www.gog.com/forum/kingpin_life_of_crime#1639047357
https://www.gog.com/forum/red_faction_series#1639462881
https://www.gog.com/forum/beneath_a_steel_sky#1630076556

EDIT: I don't know, if this works with the GOG version, but...maybe have a look:
https://gamerinfo.net/game/kingpin-life-of-crime/x360ce/?fbclid=IwAR1SCQXWClJjbJe_bq0NkBgcDXBPI-o6y2W5M36NqYKmMUeX0C5f713EvSU

This is a point and click adventure. It probably did have joystick support back in the day as a lot of early-to-mid-nineties adventure games did, but if you got it working I doubt it would provide the experience you're hoping for. Do you enjoy moving a cursor around with a joystick?

Yes, I would simply repeat what the others have said before:
Kingpin: Life of Crime, Red Faction, these are First Person shooters (and old ones at that), so using a mouse + keyboard is the best way to play them. If you have to play with controller (and you will likely not enjoy it) it has no lock on or targetting help like on console.
METAL GEAR SOLID - I don't know
Beneath a Steel Sky - This is a point and click adventure, best again to use mouse to p&c.

Of course, if you want to make life difficult and use a controller and the games do not have the option, you can use an intermediary tool like anti-micro:
https://github.com/AntiMicro/antimicro
With this you can map inputs to controller buttons.

Buy and play games on a console maybe?
I hear they all support controllers natively.