is there a book that you'd recommend to a CSS noob so that a hypothetical backend developer could learn modern CSS that allegedly does not suck in a curated and guided, not pick-your-own-adventure via blogpost and tutorials way?

If you’re not turned off by its heft, CSS:The Definitive Guide, 5th Edition by Meyer & Weyl.