I think i have finally reached a good profile. I got this profile by using the color checker shots I posted (daylight versions).
I spent most of yesterday comparing pictures with this profile and there are definitely improvements. The odd thing is that every tutorial/guide always recommends setting the white balance to before proceeding to the correction. Which is what I did with all the previous attempts. For this attempt I left the white balance as shot by the camera and now I actually get better colors.
The lighthouse still has that magenta cast, but at this point I have resigned myself to performing manual corrections in those cases.
I would like to thank everyone again for all their time and feedback.
Results
[dartktable default | darktable adjusted]