So is your opinion. If we compare the real life map and this map, then the cardinal points won't match - it's a mistake, if you're trying to make something based on real life. It's a factual error. Doesn't matter if it was designer's decision or God's fuckin will, it is a 'mistake'. One that doesn't break the gameplay, but if you lived there and knew a little bit of Geography, then chances are you would find it weird.
Well, then i am glad the makers of those great FH1 maps i mentioned made this error, even through they did so intentionally probobly =)
Real war is not fun, really. War games are fun through. People that live there are probobly 0.01% of the whole community if they even exist here. If we made the map 100% realistic one would end up digging trench for 20 hours, then when one was finally done, he would get shothead killed while drinking tee, that would be rather boring experience.
About ingamemap, like Rabbit said, the north-south is more likely to be decided by Sun location then how you hold your map, there is no north and south written on the ingamemap. As when you are running up the beach you are more likely going to turn your map up to where you are walking forward. That is why you have a tool called compass, becouse the map itself is local map that can be rotated freely. Its not like you are thinking to yourself "where is America from the beach if i hold my map this way, left or down?". Earth is round not flat like on a atlas map!
Now if we look at maps like those mentioned, Omaha, Goldbeach, Stalingrad. All of them are where one side is attacking and other defending. It is natural that the map is turned this way, as it is those that attack that would prefer it that way, that is how they would probobly turn their map when they walked up the beach forward. Defenders dont really need to go anywhere, therefore for them the map is of less importance, therefore it is also natural to favor attackers with the map rotation.
Rabbit, if you really want i suggest to put a compass on side of the map or something with correct North there... Not that it really matters, but at least it will be clear that it is not an error, rather a choice
And overally, i would say that the map rotations are a mistake of FH2 developers on many maps rather then the other way... But ofcourse, we all got our opinions =)