'Regular' vampires are the classic kind, hiding from the sun, eating the innocent, etc. They have 'remote' control over their victims. However, these guys have learned. Running water is very scary, yes, but smelling like a hobo is scarier.
The secondary Big Bad of Final Crisis (after Darkseid) is Mandrakk, a rogue, twisted Monitor who feeds on the Bleed (a.k.a. ultramenstruum) — which is, technically speaking, the life blood of The Multiverse itself. Mandrakk had once been the good and wise Dax Novu until he had been corrupted and overwhelmed by vampiric hunger. It's further revealed that all the Monitors — meta-beings from a sort of sentient super-universe in which the entire Multiverse was a mere lesion — are vampiric in this way, either by feeding on Bleed or (in a more metaphorical way) by 'leeching' on the stories of the universes they watch. One female Monitor, Zilla Valla, is seen physically feeding on Overman, a Superman from a universe where the Nazis had won World War II. In spite of the insane scale of the Monitors, Mandrakk is, in the end, killed by having a stake driven through (what is presumably) his heart. Admittedly, it's a stake composed of the joint energy of most of the Green Lantern Corps, but the principle remains. Mandrakk also has trouble coming near Superman because of the stored sunlight in his body, so he's weak to sunlight as well.
In I, Vampire, sunlight doesn't harm vampires, but instead simply weakens them. They have a number of shape-shifting abilities, and many of their powers get more powerful as they get older. They are also much harder to kill as they age and killing a sire within the first three days of a vampire being turned will cure that vampire.
Swamp Thing provides the vampires of Rosewood (volume 2, issues #38-39). Formed from a vampire colony which had been mostly destroyed when the town was flooded, the survivors (sleeping in sealed freezer units) adapted and became aquatic vampires. John Constantine explains that the vampire virus is anaerobic; running water is aerated and damages vampires, but they can tolerate stagnant water — and being underwater shields them from direct sunlight. They were even becoming fish-like.
Sgt. Vincent Velcro of the Creature Commandos is a vampire, but an artificial/simulated vampire. This means that while he lacks the supernatural weaknesses of a true vampire, he also lacks many of their more fantastic powers and is much easier to kill (though he can turn into a bat and back).
The vampires that appear in the DC vs. Vampires series have the following rules:
They mostly possess the classic powers (inhuman strength, speed, mind manipulation, etc.), are weak to holy symbols and holy water and get burned by direct sunlight (though can still operate during daytime if covered), can switch between their former living appearance and a more monstrous one when attacking and can transform into bats.
Other than direct sunlight, the only method that seems to put them down for good is a stake to the heart. When Amanda Waller blows the heads of the Suicide Squad members that were vampires, the rest of their bodies remain intact, and Batgirl even theorizes that their heads may even grow back.
The turned metahumans also retain the abilities they had in life and can use them to circumvent their weaknesses. Hal Jordan uses his Green Lantern ring to filter the direct ultraviolet light that would normally harm him, and Wonder Woman can't be pierced by a normal stake (or arrow) due to her strength and durability.
The process of turning one into a vampire consists of making the victim drink the vampire's blood, and also seems to be extraordinarily fast. After being bitten, Wonder Woman appears as a vampire at the end of the same day. When Red Hood is being turned, the process seems takes a matter of panels, though it is interrupted when Red Hood is mercy-killed by Green Arrow.
