Since this question was posted, Google most recently (early December '12) published the Android Maps API V2. Like other functions, it is designed to work with Fragment and eliminates the pointlessness of MapActivity .
https://developers.google.com/maps/documentation/android/
So, it seems that now we can happily use maps in Fragments without the need for hacking.
The only weak drawback that I have encountered so far after the initial game with this new API is that older devices seem to require the user to install Google Play Services first, which may cause some users to break a little. Like them.
source share