Applying Custom Color Profile in PS

For the record I went back and did all my PS work over.  I tried and tried and there was no way to match the color I was getting with the custom camera profile.  As I mentioned it is usually the first thing I do and I just messed up because this project was gigantic and I had my mind on other things.  But I whole heartedly agree with D Fosse below.  As an artwork photographer as well, there is no substitute to the custom camera profile to match the colors in a work from the get go.  To make matters worse this was video based artwork with really saturated colors.  I would never bother with this on my other work unless there was a reason, but I have not come across that yet.  I find Canon color out of the camera too saturated and very heavy on the green and yellow.  I am a color novice.  If anyone has advice or can point me in the right direction with that I'd be most appreciative.  In the meantime, thanks everyone for weighing in.  If it matters, I spent a couple hours on the phone with an adobe tech trying to reverse engineer this and it did not work.

Depending on how much you have edited, you could put a profiled version on top in Color mode. Some people seem to do this. I suspect it could look silly or unnatural if you've changed luminosities too much already... Maybe you can edit the raw similarly re. luminosity.

I usually take an image with a color checker and run it through the Color Checker Camera Calibration software and it builds a custom color profile

By @SRPcashie

Just so it's said, for others reading this:

You only need a special profile if the spectral distribution of the light source is different, such as LED or CCT.

Most other common light sources (daylight, flash, incandescent) have continuous spectral output and only the white balance varies, which the standard dual illuminant profiles handle natively. Under normal circumstances it's highly doubtful that you can improve on the standard camera profiles.

A color checker included in the shot can be essential for setting the white balance and building the right contrast curve, but you normally don't need a special profile for that.

No, those profiles are camera (.DCP) profiles for raw processing which is why and how you access them in Lightroom Classic or ACR. Photoshop itself only supports ICC profiles.