First, what do you need? Looking at the numbers for Apollo 12, we see 3150 m/s for TLI, 880 m/s to enter lunar orbit, and 923 m/s to return to Earth. So we need 4953 m/s delta-V from LEO orbit.
To get this, we can use the second stage engine (ISP=348) and the super Dracos (vacuum ISP roughly 240). The division of labor helps even with the SuperDraco's worse ISP, since they don't need to push the empty second stage. To make this work, we'll need about 4 tonnes of Dragon fuel. This is more than they normally carry (1.3 tonnes) but they are only carrying two people. This gives a total Dragon mass of 11 tonnes.
Is the SD's high thrust actually required in this instance? From what I've read, Dracos have a somewhat better ISP of about 300s, which would obviously increase available delta-V.
Assuming the empty Dragon + occupants = 7 tonnes, the Dragon adds 240*9.8*ln(11/7) = 1063 m/s. That's a total of 4953 m/s, just what is needed. The Dragon now needs to land in the ocean since there is no delta-V left for a propulsive landing, or even an assist.
With the rest of your figures constant, a 300s ISP nets you 300*9.8*ln(11/7) = 1328 m/s, about 265 m/s more, for margin on the flight. Or with about 3 tonnes of fuel, you can keep the delta-V the same (300*9.8*ln(10/7) = 1048 m/s.
Ah, but I'm forgetting the second stage. Hmm.
Okay, so with 3t of fuel the Dragon is 10t, so the S2 gets 348*9.8*ln((33+4.5+10)/(4.5+10)) = 4046 m/s, for a total of 4046 m/s + 1048 m/s = 5094m/s, about 140m/s more than the 4953 m/s needed.
But if you reduced Dragon fuel to 2t, then 348*9.8* ln((33+4.5+9)/(4.5+9)) = 4217 m/s and 300*9.8*ln(9/7) = 738 m/s, for a total of 4955 m/s.
So it looks like using Dracos with 4t of Dragon fuel gets you 265m/s for landing, and 3t gets you 140m/s... which would be with 240s SuperDracos, not 300s Dracos. Ack.
Fine, more math. Uh...
Okay, with 4t of fuel, and 11t total initial mass and S2 delta-V of 3890 m/s, Dragon needs to provide 1063 m/s to hit the required 4953 m/s. 300*9.8*ln(11/7.65) = 1067 m/s, so there's ~650kg left in the tanks. 240*9.8*ln(7.65/7) = 208m/s for landing on SuperDracos. That seems like lots for a propulsively-assisted parachute ground landing, but I don't know if it's enough for a fully propulsive landing, especially when you start adding in mission margins.
With 3t of fuel, S2 DV of 4046m/s, 300*9.8*ln(10/7.345) = 907m/s, leaving 345kg in the tanks, and 240*9.8*ln(7.345/7) = 113m/s for the SDs.
2.6t fuel leaves 200kg of propellant which is 66m/s for the SDs.
So, if you can use Dracos for on-orbit maneuvers, it looks like just doubling the normal 1.3t fuel load would get the job done.
Of course, lunar tourism would need to become a significant market for SpaceX to put any R&D effort into modifying the S2 and Dragon for such a purpose. It's nice to dream, but...