Funny story: back in 2015 we were continuing development on an application which was in production. We had a junior developer test this automatic conversion behavior for every transformation (even ones where it doesn't make sense). The results were quite stunning: data conversions were unpredictable, inconsistent and the database became a mess.
Our recommendation: never use automatic conversions. Always introduce an additional attribute, create a conversion microflow and then remove the original attribute.