To apply a 3D LUT in Adobe After Effects (CS6 or more recent, 2022), you have first to add an Adjustment Layer in your timeline.
Do right-click > New > Adjustment Layer:

Then, go to menu Effect > Utility > Apply Color LUT:


A window will open. Select a 3D LUT file, with .CUBE extension.
For example below, all the .CUBE LUTs from the IWLTBAP Cinematic Pack.

Now you can adjust the intensity/opacity.
In the timeline window, press “T” to open Opacity parameter and choose the proper intensity.

Done 😊

This is close to how I would explain it to someone starting out. Boundary cases are where this usually breaks, and the write-up says so plainly. Thanks for writing it up.