I don't think there is such a thing as an automatically self configuring and working wireless card... or none in my experience and from what I read on the web (may I don't search hard enough?)
However, if you like compilling for a short 25 seconds and having a super great card with a nice range and functionality, I suggest the card I have: Atheros
.
Afterwards, it was as easy in Fedora Core 4, as ./configure, make, make install, and go through the network setup