Single player games fun to play around tv / switch controls :
Firewatch - about 6 to 10 hours narrative walking exploring adventure with beautiful scenery. Teens and up probably.
Outer wilds : astonishing space exploration game. So many mysteries and puzzles and wonders and connections to be made. Cannot recommend highly enough.
Tale of two brothers. There's sadness in this game but handled very well. If you're ready to discuss life and death with your kids. Beautiful graphics and fun puzzles.
Machinerium / Botanicula / Samorost, of course. Beautiful and lovely and happiness inducing.
Tons of point and click adventures.
Coop
It takes two - might be super fun for your kids to play as parents! Beautiful graphics and fun gameplay.
Lovers in dangerous space time - technically there's guns but nothing with people or anything recognizable.
Overcooked - if no guns is really a strict mandate :)
That list above is what I was mainly thinking of. Here's a few more with great storytelling, done in various ways (sometimes non obvious but they all have a story to tell that kept me hooked)
I don't recall any physical violence in the following games, although psychological violence can be very personal and some may run you in a mood or facing events that can be unsettling at times. Some of these have neither.
Gone Home
The Swapper
Fez
Day Of The Tentacle
VVVVVV
You Have To Win The Game
Braid
Shelter 1 & 2
Her Story
Portal 1 & 2
Thomas Was Alone
One Night Stand
The Stanley Parable
Antichamber
Carto
RiME
Oxenfree
Never Alone
Life Is Strange
Soma and the Amnesia series could be of interest as well. I seem to recall it's all about fear, but not violence.
Mirror's Edge has punching but you don't kill anyone and you can avoid most encounters, with parkour style. Definitely not COD.
Limbo and Inside have gore but clearly not the COD one.
While enemies have guns and the setting may subscribe to "war-like", I seem to recall you can also complete Deus Ex Human Revolution Director's Cut without lethal action (in the original non DC bosses have to be killed) which is rewarded with an achievement at the end of the game.
Heavy Rain is also a great game with original mechanics. Don't attempt to play with PS Move, use a controller.
Some of these are good for kids, some aren't, depends on kid age and how you want to raise them!
Although they are less violent than COD, I think your memory might be a bit off on some of these. 2 examples:
In Portal 1 & 2 there are quite a lot of robots that trying to kill you with guns.[0]
In Mirror's Edge there is a lot of parkour but there's also killing people with various guns.[1]
> In Portal 1 & 2 there are quite a lot of robots that trying to kill you with guns
Correct. I should have put it aside, although the player only throws portals around to solve puzzles using his brain. And we can definitely describe GLaDOS as being a violent being.
> In Mirror's Edge there is a lot of parkour but there's also killing people with various guns
Wow I completely forgot about that in Mirror's Edge. I think I completed the game without ever using a gun and then forgot they ever existed in the game.
Overcooked 2 has been a huge relationship builder for my wife and me.
If you put your heart in it, you learn to communicate effectively under pressure (especially when trying to conquer those 4th stars), tolerate/move-on from each other's mistakes, and control your temper around each other.
We've been recommending the game to every couple we know.
Firewatch - about 6 to 10 hours narrative walking exploring adventure with beautiful scenery. Teens and up probably.
Outer wilds : astonishing space exploration game. So many mysteries and puzzles and wonders and connections to be made. Cannot recommend highly enough.
Tale of two brothers. There's sadness in this game but handled very well. If you're ready to discuss life and death with your kids. Beautiful graphics and fun puzzles.
Machinerium / Botanicula / Samorost, of course. Beautiful and lovely and happiness inducing.
Tons of point and click adventures.
Coop
It takes two - might be super fun for your kids to play as parents! Beautiful graphics and fun gameplay.
Lovers in dangerous space time - technically there's guns but nothing with people or anything recognizable.
Overcooked - if no guns is really a strict mandate :)