>>5201249Dorian Iten's light and form (very highly recommend)
Schoolism Sam Nielson's advanced color and light
CGMA Painting with color and light with Marco Bucci
NMA Bill perkens color theory bootcamp
If there is a better course that is better than these that teaches you how to paint things then I haven't heard of it. Bonus, they've all been available on here at some point or another.
I can't stress enough though that while these will teach you how to paint subjects, it won't teach you a) good character design b) perspective c) anatomy. So like the op above said, if your drawing skills are shit, it doesn't matter how well you understand how to paint.