I was talking about a number of sites all over the web (including several at Google) that user agent string sniff and tell opera that it isn't supported, not maps specifically.
But, speaking of maps specifically, maps.google.com in desktop Opera works fine, but clearly you didn't try using Opera Mobile, because as soon as you start dragging the map, it disappears.
(at least on a galaxy nexus running jelly bean)