sp_configure set at code execution - Pro/con's of turning on/off
A) Those options can only be switch by logins with elevated permissions. Therefore to alter them at run-time the application must run with elevated permissions. This is a security risk.

B) Actions performed in this way run in the DBMS's process. Any instability (bug, exception) they cause will affect the stability of SQL Server and all clients it is serving.