Like many people have said, unless there are some family dynamics that we are unaware of, I'm not sure you can miss a sibling's wedding because of a fairly small financial outlay. Even if you take travel hacking out of it, can it cost more than $1,000 for 2 round trip flights to the Bay Area and 2 nights in a mid-tier hotel?
Travel hacking: If you have some time to plan this, a trip like this would be EASY to put together with rewards points.
The absolutely simplest way would be to open two cards like the Capital One Venture (Barclaycard Arrival Plus and Cap One Spark Miles for Business would work as well) -- one each for you and your wife.
Each one will get you $460 in free travel, so you'd just put the flights on one of your credit card accounts, the hotel on the other and after the fact you could wipe out a total of $920.
Nobody knows or cares you have points -- just pay for the travel with your cards and after you've hit the minimum spend on each, you redeem your points.
There are of course many ways to do this with rewards points, so if you went the traditional route it would generally cost 25,000 miles each for a round-trip ticket in the continental US. So 50k total there.
Depending on the hotel and your flexibility, you can find lower point requirments. We have family in the Bay Area and I scouted out a Hyatt House near Oakland that is 8,000 Hyatt points per night. My sister-in-law said it's really nice, so we're going to stay there.
You could get Chase Ultimate Rewards points (Sapphire Preferred and Ink Plus primarily) and put together that trip fairly easily. Hyatt and United for instance are Chase UR transfer partners. 64,000 Chase UR (50k send to United and 16k to Hyatt) and you're on your way.
Like Alexi (Miles Dividend MD) said above, we offer a free travel hacking course that was designed specifically for Mustachians. We'd love for you to sign up -- it's free, there's no time commitment and it walks you through the concept with articles and videos.