a couple quick examples of 797 capsules that I know for a fact to be true (there are others that from memory I think are 797 too but since I can't say for certain so will note as much here:
cad m177 and m179 (179 is dual)
behringer B2 Pro (other designations of B2 as well??) it's also a dual I think, probably same cap as m179 but with vastly inferior electronics, case, screen and addons compared to the m179.
I used to hear that the mxl v67g was 797 but apparently (according to someone in the know) it's built by some engineers who left 797 and started their own small capsule manufacturing plant. the end result is a capsule that's a lot like a 797 capsule, probably costs a little less, but hasn't nearly the testing and q/a gear that 797 audio has (797 audio actually has very good microphone testing equipment, one of the only if not the only chinese microphone company that does).
ones that I "think" are 797 but I might be wrong: studio projects B-series ldc mics (I owned two of the cardoid ones, B1 maybe but don't recall # for certain, sounded similar to my cad m179s in cardoid mode but not quite as good which could be chalked up to the cad's superior build and electronics, anyway I'm not 100% sure those SP mics are 797 capsules. Also I believe (but could be wrong) that the SP C-series LDC mics use caps from another manufacturer but again I could be wrong).
the long extinct MXL V77 tube mic I'm pretty sure used a 797 audio capsule.
anyway, there are no doubt other cheapo mics using these great capsules. I'm trying to avoid listing the more expensive onces (although v77 is getting up there). for example many companies that use chinese components for their well respected mics use 797 capsules for at least some models, I think ADK might use them for some models but again that's not for certain and I expect they're not used for all models even if at all.
From what I understand, 797 makes only one or two models of LDC capsule and they pretty much have the common sound of being relatively flattish and relatively free of peaks and nasty resonances, they have more air up high without a nasty 5-7khz bump that you get from some other chinese capsules, however the 797 caps also as a result tend to be a little more versatile yet not your traditional "vocal" microphone frequency curve (old school vocal mics do tend to have a mid presence and sometimes a push in the highs, but the better mics like that manage to somehow avoid the nasty harshness one gets from several of the alctron capsules which otherwise on paper might appear to be ideal vocal mic caps). There are certainly good caps from alctron et al, esp those that do mimick classic german vocal mics, but somehow they always seem to have more phase issues and other problems (also are often mistuned from the factory) and therefore the best cheap bet always seems to be the 797 capsules.
If one wanted to (i've been wanting to for example... ;-) one could make a resonance or similar type of eq circuit for use in a 797 cap based mic and voila, switch it on for vocal use.
by the way, I'm totally not an expert, but I read a LOT about this stuff, have a good memory about dumb anal things like capsules and frequency response curves (but would forget my head if it wasn't screwed on) and I use my own experience from owning many of these types of mics over the years and trying to use them professionally. I don't build or mod mics extensively myself (but am credited with a bit of work in the classic apex 460 mod pdf that's circulating around...) and although I'm good with electronics and with the math behind acoustics my own mechanical skills are pretty limited. The real microphone geniuses out there will tell you things I can't and no doubt can/will correct me (please!) when I'm wrong.
I'm fairly certain I'm correct about the contents of this post however.
cheers,
Don