I am running Lightroom Classic version 10.0. I recently purchase a Canon iP8700 inkjet printer. I went to print a photo and could only use with Manage By Printer under Color Profile. Needless to say the print was awful. I went and checked under "Other" looking for a Profile which could be managed by Lightroom. There was nothing listed. Where can I get the appropriate Profile?
Normally these get installed when you install the printer driver. So, from Canon, download the driver and install.
You are using what paper? Profiles are paper specific as well as printer specific and such a profile may not exist (meaning you need to build one or have one built for you). If a non Canon paper, that's why one doesn't exist from the driver install.
I just checked the Canon website and there doesn't seem to be any paper profiles available for that model. I looked at Red River, and there are paper profiles for the IP8720, but none for the 8700. So I question whether or not that printer even supports paper profiles.
That is a common problem, and not necessarily “user error.” Many users are tripped up by the AirPrint driver getting installed by default, that driver is not fully featured. The fix is exactly what you did: Make sure to download and install the fully featured driver. But none of that is obvious, you’d have to know or be told to do that.