A Multifaceted Phenomenon of Hydrophobic Effects: Insights Learned from Nucleation Algorithm Based Computer Simulation Approach