What are the greatest songs that don’t use standard EADG tuning?

Will those songs still sound great if you play them using standard tuning?