Confidential clearance does not seem stringent. You can avoid reinvestigation for 15 years, while secret needs to be reinvestigated every 10 years.
I've generally heard that secret level work is pretty boring, so I doubt confidential would be better.