Can Checksum alerts make it to the end user? I've been reading

https://www.brentozar.com/archive/2017/02/lets-corrupt-sql-server-database-together/#comment-2539669

and I've got some databases with Torn Page Detection that I need to change to Checksum. I've already run (and scheduled) my CheckDB's and we've got no corruption.  

Question: If I enable checksum, and a page gets corrupted, can any of my end users get errors in their applications?
Yes, any corruption alerts can make it to the end user.

To see it yourself, grab one of the corrupt databases from Steve Stedman's Corruption Challenge. Attach the corrupt database to one of your development environments, and run the query that Steve describes for that database. You'll see corruption errors - just as your end users would.

Your application (C#, Java, whatever) can be coded to trap incoming errors and display different things to the users, but that's an exercise left for the reader.