How can I play against a real opponent in Heroes of Might and Magic V?

You can play through the ubi server. To do this, go to "Multiplayer" -> "ubi.com". You need to be registered on the Ubisoft website.

It won't slow down your internet connection. However, I don't know if 232 MB will be enough.