Optical Substructures in 48 Galaxy Clusters: New Insights from a Multiscale Analysis