For $500 your best bet is a Nikon D40 (new if you can find or just look for a good condition used model) and whatever lens you can afford to go with it - probably the kit lens.
If you're willing to spend a little more time willing how to use it, your photos will be infinitely better than any sony point and shoot.