Indexing and Google's Core Updates, Product Review, Helpful Content, & Spam Updates

Something I've mentioned here and there in passing on the forum, I think, deserves to get a full mention, if only to draw more attention to it so there's more brains thinking about it and providing insight is... indexing and how that relates to Google's 2022 Core Updates, Product Review Updates...