Hello @MDMR, it is possible to enable some of those animations on codrop, each is different, so you have to check those out individually, but as an example integration of an effect from codrops, you can check out this post, where I have integrated one particular effect into an example Webflow page:
Check that out, to give you and idea, what need to be done. Depending on the custom code you are using, if you are needing to add script, you add that to your Before Body section of Custom Code settings, or css style related code to your HEAD. There are also exceptions from time to time, where you may need to put script also in the HEAD, but generally, put that in your Before Body section. CSS can always be put in the HEAD of the Custom Code section of your site settings.
I hope this give you a direction to look in. Cheers!