I think the main issue with these tutorials is they don't really teach you any ways to really use the 6502 instructions. Nerdy Nights at least tells you what they do, but leaves you to look at the source code to figure out simple things like if statements.
Things like checking bits, subroutines, and 16 bit math should all be covered before you ever start using any NES/PPU registers. Nerdy Nights does cover all these things in week's 7 and 8, but only after trying to teach something complicated like collision detection, background loading...
You should learn how to do program in 6502 before ever starting with the NES. If I wrote a tutorial, I wouldn't advise continuing on to the NES stuff until they could do some fairly complex 6502 problem solving, like how to flip the carry flag without using a branch statement, clc, or sec. Maybe even how to rts someplace without a jsr before it, and without corrupting the stack. Stuff you'd rarely do, but would get your mind thinking about what sorts of problems you could solve with the instructions.
This particular one (Playpower) would actually confuse the hell out of me if I didn't already know what he was doing. In part two, he said we write the address of the palette in two writes. But none of the parts said that lda, and sta are what are making this happen. He never explained that you need to write to that specific address for this to take effect. I'm left to connect to the dots.
He says we clear the memory, but doesn't explain loops or why the code that is there works.
One day I'll stop complaining and write my own tutorial, so people can complain about mine.
edit: I guess another problem I have with online tutorials in general, is that it's too easy to jump ahead. Let's say I asked you to do something like flip the carry without branching. I would probably have to give you an answer in the tutorial, which you could "peek" at. And then you'd say, "Oh, I get why this works." and you will have gained none of the problem solving skills the exercise was for.