well it's not necessarily to make it look unreal! that usually comes with over-use of the technique.. it's basically to allow different areas of an image to be exposed to different levels, i.e. so you can see details in the bright sky as well as showing something that might be in shadow on the ground.
i'm not a big fan of the technique myself but it can be useful on occasion.. my advice is don't take it too far!