I'm interested in knowing your test results. I see different behavior when connected via wi-fi than when connected via AT&T's cellular network in regards to photo attachments appearing inline or viewed in place automatically when connected via wi-fi, but not always when connected via the cellular network. With a large photo attachment - over 3MB that I received recently, I had to select the attachment in the message body to download the attachment in order to view the photo when connected via wi-fi, so it isn't always consistent, but I'm fairly certain the attachment would not have downloaded automatically when connected to the cellular network if it didn't when connected to a wi-fi network.
In regards to the Mail client being smart enough, the YouTube app will stream better quality for a selected video when connected via wi-fi than when connected via the cellular network, so hopefully it is the same with the Mail client.