I am contemplating converting my Core node to Knots, because I do not the idea to be pushed that nodes can be used to store CSAM or malware payloads.

It would be disastrous for the entire community if somebody executes this use case. We will be pushed into an enclave like the Monero community.