Yep, this is what we do. Adding in some kind of object cache cluster wasn't a significant enough of an improvement over just hitting mysql to justify the extra point of failure.
The problem is WP just makes a ton of simple queries - in any complex install the bottleneck is probably going to be network latency to the database.