K.F.
Personally I would do Housekeeping Camp over Curry Village for a couple of reasons. You can have a campfire, cook at your "tent" and really experience nature. Curry village is, just as the name implies, a small city of tents very close together. You must eat at the cafeteria for every meal. As for Housekeeping, it's a little more rustic but if you buy a cooler when you arrive (you'll likely need one for the rest of your trip anyway) you can cook at the site. They have bedding, firewood and other camping stuff to rent (very cheap) or buy for the people who travel by air. Get a river view site and wake up to the Merced river at your doorstep and half dome towering above.
You need to rent bikes for a day of cruising around the valley, skip the cheesy tour deal and ride around to find a little more privacy. The main areas will be crazy in the summer but if you plan right and go where the crowds aren't you will have a much better experience.
Staying in a hotel in the valley you will feel ripped off. The "budget" place is Yosemite Lodge and it'll run you over $250 for a dumpy little room, Awahnee is $500 plus and the catch is you will NOT feel like it's worth it. Basically quadruple other rates at hotels you've stayed at, you're paying for the location not the room.
Trying to drive back and forth to the Valley will not afford the same experience as actually staying there so I would plan a couple of nights roughing it in the valley and then splurge on a night at The Tenaya. It's an awesome family resort and there is tons to do on that side of the park.
We go to Yosemite frequently and it is really one of the most amazing places on earth. PM me if you have other questions about your trip. Not only have I lived in CA my whole life, traveled all over the state but I am also in the vacation business. Good luck!