I don't think the Accepted Answer necessarily means that (and I agree with you - it doesn't make sense)
"In my experience the only time [OPTION RECOMPILE] is a viable option is when you are using dynamic SQL"
I wonder if the O/P meant dynamic SQL in the sense of "variable parameters" (which are then discussed - "if you create the query where there are 10 records in your database and then execute it when there are 100,000,000 records the cached execution plan may no longer be the most effective." )?
FWIW we use sp_ExecuteSQL in preference to EXEC in order to try to improve the likelihood of the SQL statement (not changing and) being cached.