I think the best AMD card that comes in a single-slot configuration is the HD 7770.
Don't know about Nvidia though, but I would presume there won't be a single-slot GTX card.
EDIT: The best Nvidia single-slot card is the GT 640, which is nowhere near as good as the 7770.
Hence, the 7770 is the best single-slot card available.
/thread.