Gila. Rapid lights and medium dornes will allow you to get to 45 km application (some NPC range) as well as 3-5 km (frigate range). Passive tank will help you under neut. If you are good with d-scan you will be able to make 300-400 milion ISK before someone pop your 600 milion ship. At the end you will be only like 200-300 milions minus, which can be fixed in 4-6 hours of high sec security mission running.
TL;DR : skip C2 PvE, not worth it.
Not sustainable for char with low SP and bad corp standings. Normal mission runing will give you 50-60 milions an hour. The burner blitz is a way but out of reach for most mission runners. I mean real runners, who is doing them for hours. Not those, who manage to get 50 milions from 2 burners in 15 minutes but than stops cause it would harm his stats or standings.
Ok, so, drake is a well known WH PvE workhorse, but as you already found out, it is because of tank, not because of DPS. Talos is a no go because large guns will do little damage to rather fast small / medium targets and C2 is all about NPC frigs and cruisers. Here: (Rykki's Guides: Wormhole PvE (v. 1.19) - Google Drive) you can see , that you need to tank about 300-400 DPS at least if you are in battlecruiser (hard to sig tank in it) and you targets will often tend to run 45 km from you (or circle very close). Sleepers tend to eat drones and you will face neuts in C2.
I know some people use artillery fit Hurricane Fleet Issue to do the job (tracking bonus helps) but I think T2 cruisers are best suited for the environment. The cost of the lost ship will be significant, though…
You can try
[Drake, C2 PvE active tank]
Ballistic Control System II
Crosslink Compact Ballistic Control System
Crosslink Compact Ballistic Control System
Crosslink Compact Ballistic Control System
Adaptive Invulnerability Field II
Dread Guristas EM Ward Amplifier
Dread Guristas Kinetic Deflection Field
Dread Guristas Thermal Dissipation Field
Large Shield Booster II
Medium Capacitor Booster II, Navy Cap Booster 800
Core Probe Launcher I, Core Scanner Probe I
Heavy Missile Launcher II, Caldari Navy Scourge Heavy Missile
Heavy Missile Launcher II, Caldari Navy Scourge Heavy Missile
Heavy Missile Launcher II, Caldari Navy Scourge Heavy Missile
Heavy Missile Launcher II, Caldari Navy Scourge Heavy Missile
Heavy Missile Launcher II, Caldari Navy Scourge Heavy Missile
Heavy Missile Launcher II, Caldari Navy Scourge Heavy Missile
Medium Anti-EM Screen Reinforcer II
Medium Processor Overclocking Unit I
Medium Semiconductor Memory Cell II
Hobgoblin II x5
About 100 milion ISK, tank up to 400 DPS cold and still can apply about 500 DPS as far as you drone range is. Reload time will kill some DPS, but you can hit any target you need, even without prop mode.