Well, there is this Artbook called OBLISKURA which is pretty cool and it's about giant creatures that are good and evil gods or whatever and I think it's pretty cool setting but I don't find any novel that's similar to that, giant op creatures (not giants, but like they are big) that interact with the world constantly instead of being your typical god where everybody mentions but fuck knows where is he or what he does. I find Shadow of Colossus setting really cool so I wonder if there is any novel that's similar to that
This's not exactly what are you looking for. But these novels have similar vibes of Shadow of Colossus. The Grim Company Series by Luke Scull Way of Kings by Brandon Sanderson The Godsfall Chronicles