This Skyrim mod is actually called "Here There Be Monsters", and it adds nine huge sea monsters into the Ghost Sea to the north of Bethesda's chilly realm. But I've focused on the Horkers because, well, just look at that screenshot. It is a giant beast with a huge tooth. Look, though. Really look. See? He's not a beast. He's just a thing that society deems to be big and scary. And so he acts as society imagines he should, and tusks everything and everyone. To be fair, he is part of a society of angry Nords fighting dragons and in the midst of a civil war. He should probably move somewhere nicer.
Thanks to this mod, there are other tragic giants wandering Skyrim's north. There's a lore to the mod that draws real-world inspiration for the blubbery behemoths and their big brethern. There are giant crabs, huge fish, sea beasts and kraken to be found in the ice-rimmed oceans. The nautical nasties are all tied to specific locations, so you can take on the mantle of a monster hunter and track down their lairs.
To help with that there are quests that'll hint at their locations, and ship captains an expert hunters can be hired in the inns at Solitude, Dawnstar, and Windhelm. Find them and you're on your way to death or glory. I'm going to guess death, but you could always prove me wrong. I did look for trailer or demonstration, but none were thrilling or interesting, and one was annoyingly sexist, so instead here's a mini-gallery of some of the things you'll fight should you choose to download the mod.