Cheat Engine (CE) is a legitimate memory scanner/debugger used by developers, researchers, and modders. The executable from cheatengine.org is clean. Risks come from where you download it and how you use it.
CE is a powerful learning tool for reverse engineering, vulnerability research, and game modding. Using it to ruin multiplayer experiences or steal IP crosses the line. The tool isn't the problem—intent is.