Here's a good overview of the cuts.
Sirloin is often held up as the best, but I think it's too tough. I like rib eye, which has a bit of fat marbling.
Edit: I actually like filet mignon the best, but it's really expensive and tricky to cook correctly.