Good luck man. It's doable, and I've done far trickier things, but I've been at it for a long time.
What I would do is this:
Obtain the following:
A single strand of copper wire - Like a little scrap from a multi-strand cut-off. THis is not going to be 'high current' - Even a very thin wire will do
A 'fine tip' soldering pencil (like <1mm width at the tip)
Very thin solder - Thinner than whatever you have on hand. They sell stuff that's like a 40 AWG wire or so. That's what you want here.
A microscope or other magnification means if possible
Start by scraping the solder mask (the green covering) off that via that's located below and to the left of the missing pad. Use an exacto-knife, but scrape in the OPPOSITE direction of "cutting"... i.e. drag the tip a few times, and the green-stuff will sorta crack & break up. DON'T CUT INTO THE COPPER!!! Use a fresh blade if possible, makes the work much cleaner and faster.
Solder your wire to that via. Bonus points if it fits INSIDE the via (but it might be clogged with solder-mask)
Clean that cr*p solder off the good pad with a piece of solder-wick (cut it down to a thin strip if you need - Don't use a huge wide piece - It'll act like a heatsink and stop your process)
Put a small blob of solder on the 'good' pad, let it cool.
Hold the new capacitor down on top of the solder blob, and hit the blob with your soldering tip - THe solder will 'reflow" and pull the capacitor down (guide it gently with your tweezers).
Now it'll be easy to solder that wire to the other side of the cap
If you dwell on the cap for more than a second or two, throw it away and get another one. It's super-easy to fracture a ceramic cap with too much heat.