With the new phones you have no choice as SIP is the only protocol since Cisco decided this will be de-facto protocol for phone control.
For phones that support both SCCP and SIP, my recommendation is to leave them as SCCP for time being unless there are specific reasons not to. SCCP vs SIP feature parity in latest versions of CUCM are pretty much the same.