Can't find lens profile after importing

"However it is present in the imported files under C:\Users\*username*\AppData\Roaming\Adobe\CameraRaw\LensProfiles\1.0\Imported"

That's the correct location for imported lens profiles.

"However, the profile doesn't appear in the lens correction section. "

1. In the Lens Corrections panel, you've clicked Enable Profile Corrections, then the correct Make, then the Model?  To verify you're looking for the right Make and Model, open the .dcp file in a text editor and look for these two lines:

stCamera:Make="Canon"
stCamera:Lens="EF16-35mm f/2.8L III USM"

2. Most lens profiles apply to raw photos only. In the .dcp file, look for this line:

       stCamera:CameraRawProfile="True"

If it says True, then it applies to raw photos only; if it says False, then it applies to all photos.

3. If it says True, then your DNG file may or may not be considered by LR as a raw photo, depending on how it was created. Edit a known raw in Develop (e.g. an NEF or ARW) -- do you now see the lens profile in Lens Corrections? If you do, that indicates the DNG file is not considered a raw file -- provide details about how it was created/converted (from which file type?).