What kind of camera is right for me?

Yes you have a created an impossible camera for your budget, sorry. Also crisp good quality pictures dont come from having more megapixels necessarily. A crisp picture is accurate focus, a good lens, and good lighting. Most DSLR are more than $500 body only your best bet is probably to get an expensive point and shoot like the Canon G12 or something.