The CC3000 hits that sweet spot of usability, price and capability. It uses SPI for communication (not UART!) so you can push data as fast as you want or as slow as you want. It has a proper interrupt system with IRQ pin so you can have asynchronous connections. It supports 802.11b/g, open/WEP/WPA/WPA2 security, TKIP & AES. A built in TCP/IP stack with a "BSD socket" interface. TCP and UDP in both client and server mode, up to 4 concurrent sockets. It does not support "AP" mode, it can connect to an access point but it cannot be an access point.
ِAdafruit wrapped this little silver modules in a tidy breakout board. It has an onboard 3.3V regulator that can handle the 350mA peak current, and a level shifter to allow 3 or 5V logic level. The antenna layout is identical to TI's suggested layout ,Adafruit is using the same components, trace arrangement, and antenna so the board maintains its FCC emitter compliance (you'll still need to perform FCC validation for a finished product, but the WiFi part is taken care of). Even though it's got an onboard antenna the raneg is as good as a smartphone's.
New! As of 3/20/2014 we are shipping v1.1 which adds a tri-state buffer to the MISO pin so that you can use the CC3000 with other SPI devices on the same bus.
Each order comes with one fully assembled and tested breakout and a small stick of header you can use to solder in and plug into a breadboard. Adafruit don't have a detailed tutorial yet but to get you started, Adafruit got you a fully working Arduino library that is based off of TI's codebase but adapted for use with the AVR. there is example code showing how to scan the SSID's, connect to your access point and run DHCP, do a DNS lookup to IP address, ping a site and connect to a remote TCP socket such as a website and print out the page.
Please note the hardware is good, but the library code does not yet support all of the CC3000's functionality. At this moment, SSID scanning, connection, DHCP, DNS lookup, ping, and UDP/TCP client & TCP server connections (eg connect to a website and grab data or host a very short website) all work and are tested with example code. Check out Adafruit tutorial for wiring and Arduino library downloads
For use with Arduino Uno & Mega only at this time.