It took me several YEARS after going from film to digital to even know there WAS such a thing as white balance. I should have known from the start. After all, I had too many filters to handle this kind of lighting with daylight film, or that lighting with slide film, etc.
So then I started to learn about WB, on this website, mostly. I 'discovered' that auto white balance worked 'pretty good' for most common lighting situations...sunlight, cloudy, indoor tungsten lights, and so on. But throw in florescent lights and their 60 cycles per second, it gets nasty. Add in daylight coming through the windows with florescent or even incandescent lighting, the WB changes every 12" or so.
So, I learned how to set custom WB in the camera and started with an Expodisk. Worked great...as long as I had the same lighting. I had a small family party a couple years back to shoot and due to indoor lighting and a wall of windows, and a brick wall opposite the windows, I took Expodisk shots in each of the 4 directions and then set WB to the Expodisk frames I shot 'up front'. After 50 or 60 shots, having to manually search backward to get the correct Expodisk frame to set the WB became time consuming. I should have re-shot the Expodisk shots to reduce the going-back time.
So then I tried an X-Rite Color Checker a couple shoots later. The color matching was superior to Expodisk. But once I encountered a slightly different mixed lighting combination - aiming 3 or 4 feet left or right of the earlier subject, the colors were 'off'.
OK...grey card time. Similar results. Good colors, but have to have a different shot for every lighting situation.
Fortunately, sometime after I tried Expodisk on a few shoots, I decided to 'try this RAW thing". Unfortunately, I was still using an 'antique' version of Photoshop "Lite Edition" (Win 98 freebie that came with my Canon G3), and I don't think I ever found the white balance adjustment, if there ever was one. So I ended up screwing with individual colors, one at a time, until I was pleased.
Fortunately, I had migrated to Lightroom shortly thereafter and starting using the Color Checker add-in for LR and the Color Checker device. But that got rather tedious having to have several Color Checker shots depending on lighting conditions.
So, I tried CWB using the grey card for JPGs from the camera, and ultimately gave up with CWB completely. I tried using the grey card shots in Lightroom to set WB at that point, and still, having to scroll backward to get the shot to set to became problematic.
Let me digress for a moment to state that I take most of my photographs these days as 'candid' shots, typically in availble light, without flash, and usually at indoor, non-wedding church events with all sorts of lighting conditions. Perhaps 15-20% of my shots are outdoor daylight shots. So for me, I may take 2-3 shots aiming one direction in a room with mixed lights, then turn 180 and take a couple more shots. In short, a WB nightmare.
So these days, I set my camera to AWB and shoot RAW + JPG. IF I'm shooting for my own personal work, I may shoot JPG only. I use the JPGs primarily to get a preview on the computer as a means to delete corresponding RAW images before I import into Lightroom. Most often, there's something white in a picture or series of shots I can set the WB to. Then I make minor adjustments to the WB as needed, and use the synchronize function to set WB in the rest of the series.
My thinking these days is that if I have consistent lighting for most of the shoot, then, by all means get the best in-camera WB as possible. If I had a studio, that's exactly what I'd do. But for the amateur that I am, close-enough WB is generally good enough WB. AWB is also getting 'smarter' with each newer camera.
And one more thing...I got an X-Rite Color Munki with a gift card I received last Christmas. NOW my colors are near perfect!