I need videogame titles where all kind of insane spectacular stuff happens

Boo Bunny Plague, because Boo Bunny Plague.

Just Cause 2 has excellent frantic events both inside and outside missions.
The very first mission already probably has more explosions than most Call of Duty games in the entire campaign.

Titanfall
Crysis 3

Spec Ops the line

XCOM for the all times you watch your soldiers get murdered by various weapons and aliens in action cam.

Green Hill Zone of Sonic Generations is I think a cool benchmark to see the similarities between it and the original but the depth of the modern graphics.

You could do some real impressive mods with Skyrim of course.

A few levels into Hitman Absolution- The chinatown level i think is the first- there are HUGE crowds of people.

i'm not sure about effects in large scale, but the intro animation from Witcher 2 is spectacular!

Explosions? Just Cause 2.

If you want something spectacular I would go for these games if you had them:

Arma 3 (Make a huge battle and watch things pan out, plus fact you can have a 250km battlefield)

Star Citizen (CryEngine 4, need I say more?)

Freespace 2 (with Graphics Update, some of the user made cutscenes are pretty good)

It's a bit old, but Red Faction Guerrilla has destructable buildings, so you can make amazing things there.

From the topic title I'd say Goat Sim.

异域狂想曲/A Rhapsody of Strange Land: The Fool Plate.

Most FPS games since 2008.

Max Payne 3 for example.

Loads of cool shit happens in Dead Space 2

Far Cry 3: Blood Dragon maybe?? I just enjoy the neon of it all and all the dumb jokes.

Sants Row 3 has some crazy stuff.

bad rats

I haven't played it, but I think Metal Gear Rising may be what you're looking for.

Astebreed has plenty of stuff blowing up, DmC: Devil May Cry could qualify with how the limbo world morphs around you. I'd also offer Contra Hard Corps for more classic material, but you'll have to emulate it. It doesn't have an official PC release. Would fit the bill though, as it opens with ramming an APC through a horde of enemies and doesn't ease up from that. Come to think of it, Gunstar Heroes is a Genesis classic that is available on Steam, and would qualify if you want comedy along with your stuff blowing up.

The Darkness II? It's like dripping coolness.

How about Ryse: Son of Rome? It is surely a spectaсle, that was created to show off, what consoles can do, but now is on PC.
The gameplay surely sucks, cause it's mostly QTE, but the graphics are really good, cause it's a Crytek. Metro2033 and last light have a lot of cool scripted events, but the great ones are mostly at the end of the game, and the beggining can seem boring.

has no one said Borderlands?
That game is the defiition of random

Carmageddon Reincarnation, RAGE, Serious Sam 3 BFE, Command and Conquer series in 3D, Driver San Francisko, Saints Row games, Red Orchestra 2, Killing Floor, Ravaged Zombie Apcolypse, Pressure, Post Apoclyptic Mayhem, Payday games, Orion Prelude, Nosgoth, Mafia II and Mafia City of Lost Heavens, Godfather and Godfather 2, Loadout, Left 4 Dead games, Jet Gunner, Hotline Miami, Heavy Fire Afganistan, Dino D-DAY, Crash Time 2, Pursuit Force and Pursuit Force Extreme Justice, Twisted Metal on PS3, Borderland games, Anomaly games, Crimecraft, Tactical Intervention, Warframe, ZMR, Hazard Ops, Counter Strike Nexon Zombies, Blaze Rush, Death Rally, Call of Duty games, Resident Evil 4 RE5, R6, RER, The Typing of the Dead Overkill, Dead Rising games, Warhammer Dawn of War 40K games esspecialy Space Marine, Red Faction Guerrilla and Red Faction Armageddon, Split Second, Need for Speed games, Far Cry games and Far Cry 3 Blood Dragon esspecialy, Crysis games, Worms games, Orcs Must Die games, Shank and Shank 2, Sniper Elite V2 and its two zombie games, Sniper Elite V3, Max Payne games, Doom games, Duke Nukem games, Natural Selection 2, Dead Island games, Deadpool, Insurgency, Metal Gear Rising Reveangance, Shoot Mania Storm, Godmode, Mortal Kombat Complete Edition (MK9), Defiance, Ace of Spades, How to Survive, Middle Earth Shadow of Mordor, The Evil Within, Killer Is Dead, Meltdown, Infectinator Survivors, Infinity Runner, Marlow Brigs, God of War games, Resistance games like Fall of Man and Retrubition and etc., Dead Effect, Wasteland 2, Chaos Domain, Road of the Dead, Contagion, Kingdom Rush, Flashback, Sledgehammer / Gear Grinder, Delta Force games, Rekoil, Watch Dogs, Gas Guzzlers Extreme, Bound by Flame, Call of Juarez Gunslinger, Fallout 3 and New Vegas, Nuclear Dawn, Burnout games, Flatout games, The Witcher games, Nation Red, Battlefield games, Kane and Lynch Dead Men, Just Cause games, Ride to Hell Retrobution, Wolfenstein The New Order, Alien Rage, Zombie Driver HD, Intrusion 2, Rise of the Triad, Cortex Command, DmC Devil May Cry, Spec Ops The Line, The Bureau XCOM Declasified, Medal of Honor, Frontlines Fuel of War, Broforce, The Expandabros, Alan Wake, Awesomenauts, Alien Isolation, Hawken, Sleeping Dogs Definitive Version, The Ekder Scrolls Online, Death Skid Marks, The Red Solstice, Lords of the Fallen, DiesselStormers, Road Redemption, Evolve, Ryse Son of Rome, I Shall Remain, Undead Overlord, Falling Skies the game, Bltizkrig Anthology, Second Chance Heroes, Collapse, Murder Miners, World in Conflict, Tomy Clancys End War, Terra Tech, Magicians and Looters, OTTTD, Dragon Age Origins Ultimate Edition, Tom Clancys Rainbow Six Vegas 2, Call of Juarez Bound in Blood, Battlefield Heroes, Heroes of Newerth, Cossacks Back to War, Brothers in Arms games, Deus Ex, Human Revolution, Bleed, Ultra Street Fighter IV, Interstellar Marines, Supreme Commander games, Binary Domain, Deadlight, Inversion, Wargame games, Minimum, Clutch, Castle Miner Z, Door Kickers, The Club, Obscure 2, The Crew, Timeshift, Killzone games, Skullgirls, Gauntlet. APB Reloaded, Double Action, Zombie Panic Source, Fear Online, Warthunder, World of Tanks, Heroes and Generals, Tom Clancys Ghost Recon Phantoms, Firefall, Titanfall, The Mighty Quest for Epic Loot, No More Room In Hell, Quake Live, Magicka Wizard Wars, Archeblade, Blacklight Retrubution, Fistfull of Frags, A.V.A. Alliance of Valiant Arms, Tribes Ascend, Warrock, Raidzerz, Dizzel, Super Monday Night Combat, Global Agenda Free Agent and Gunz 2 The Second Duel. Hope it helps, check before you play ofcourse.

Night Trap

You would love Uncharted! But you know..