The challenge is that DNG like many other "standards" is really a LOT of things.
A DNG is a big "container" for data. It can contain the original RAW data from a camera (say, a Canon RAW file), or it can contain "linearized" data (which is not at all the original RAW data, and has some processing applied). Aperture typicaly supports the former, but it does not currently support the latter. So just seeing the DNG file extension is not sufficient - you have to know what's in the DNG itself.
Also, a DNG file can BE a RAW file itself. For example, Leica RAW files are DNGs. Aperture didn't support these until it supported the cameras, so again a DNG from a Leica is different to one from a converted Nikon or Canon RAW image. One started in-camera as a DNG, and others were converted to it. You have to know the format of the image data inside - that's important.
And also, like many standards, there are multiple versions of the DNG standard ("standard" is a bit of a loaded term here: Adobe controls the "standard" and have submitted it to a standards body, but they really control the standard; it's not a vote-by-committee which is good and bad). Recent DNG versions (I think it's up to 1.6 or 1.7 now?) brought things ike lossy DNG compression and other things that Lightroom uses in its new "smart previews" feature leveraged in Lightroom 5 and the new Lightroom Mobile for iPad. Aperture does not support these versions of the DNG standard right now, so any DNGs created this way (say by creating smart previews, and exporting those as DNG files), won't work with Aperture. This isn't unusual - if you created a PDF in Adobe Acrobat today and tried to open it in a PDF reader from 1998, it wouldn't work.
All ways of saying "A DNG is not a DNG is not a DNG" because there are various feature sets, and various spec versions, that are necessary to know. It's a bit of a matrix of pain 😉 But if using DNGs is more important to you than editing or managing photos, going Adobe is probalby the best bet because they write this "standard" and thus tend to offer the leading-edge support because they update the spec as they implement new features that would be good to have in the spec.