I never use Persist Security Info, and I will have to admit that I really know the effect of it.

Wether to use Integrated Security=SSPI, or Username + Password depends on the context the application is working in. For a general application, I would permit the user to choose. But your the requirements in your organisation may be different.