How to wipe certain files from Time Machine Backups history but keep recent copies of them in case of a full restore
Time Machine doesn't create bootable backups in the first place, and apart from the initial one they're not "full" either.

Individual folders/files as not valid targets for tmutil delete anyways, so selectively deleting parts of snapshots like you want is not possible. But that doesn't matter much since system and app updates are infrequent enough and small enough I can guarantee they're absolutely dwarfed by your general day-to-day ~ throughput.

If you're tight on space and want to optimize what you need to do is get BackupLoupe and look for anything that frequently takes up a lot of space in your snapshots. Cache files are already excluded automatically but some apps do put stuff in ~/Library/Application Support that effectively is cache, without being marked as such. Usually gets flagged correctly eventually but I've kept some Spotify and Chrome databases excluded, for example.