Efficient energy management relies on uncovering meaningful consumption patterns from large-scale electricity load demand profiles. With the widespread adoption of sensor technologies such as smart meters and IoT-based monitoring systems, granular and real-time electricity usage data have become available, enabling deeper insights into consumption behaviors. Clustering is a widely used technique for this purpose, but previous studies have primarily focused on a limited set of algorithms, often treating clustering as a black-box approach without addressing interpretability. This study explores a wide number of clustering algorithms by comparing hard clustering algorithms (K-Means, K-Medoids) versus soft clustering techniques (Fuzzy C-Means, Gaussian Mixture Models) in segmenting electricity consumption profiles. The clustering performance is evaluated using five different clustering validation indices (CVIs), assessing intra-cluster cohesion and inter-cluster separation. The results show that soft clustering methods effectively capture inter-cluster characteristics, leading to better cluster separation, whereas intra-cluster characteristics exhibit similar behavior across all clustering approaches. This study assesses which CVIs provide reliable evaluations independent of clustering algorithm sensitivity. It provides a comprehensive analysis of the different CVIs' responses to changes in data characteristics, highlighting which indices remain robust and which are more susceptible to variations in cluster structures. Beyond evaluating clustering effectiveness, this study enhances interpretability by introducing two decision tree models, axis-aligned and sparse oblique decision trees, to generate human-readable rules for cluster assignments. While the axis-aligned tree provides a complete explanation of all clusters, the sparse oblique tree offers simpler, more interpretable rules, emphasizing a trade-off between full interpretability and rule complexity. This structured evaluation provides a framework for balancing transparency and complexity in clustering explanations, offering valuable insights for utility providers, policymakers, and researchers aiming to optimize both clustering performance and explainability in sensor-driven energy demand analysis.