I've actually had a Mac compromised before after being lazy about the password setup. I suspect it difficult for the botnets to get traction, but they're certainly trying.
UNIX isn't inherently secure to begin with, in fact initially security for UNIX was an afterthought. It wasn't until it started gaining widespread use that the UNIX developers started taking security seriously. I went through the transition from having encrypted passwords in the /etc/passwords file, which everyone could read (or no one could log in) to /etc/shadow as security started becoming important.
That said, there was a virus around 8 years ago that specifically targeted a bunch of NCSA UNIX machines, and they ended up getting caught with their pants down -- there WAS a fix already available that would have blocked the virus, but the NCSA admins hadn't been diligent about installing it.
I think the reason for this is two fold, firstly, to write a viruses on the Mac, which by their nature need to spread, is harder due to the (*nix) security models used. But also, it seems to me viruses are getting passé and targeted emails with trojans are becoming more popular.
Trojans are one thing that Macs have been shown to be susceptible to although often by fooling (social engineering) the person into clicking all the right buttons and typing in their password.
I would therefore suggest that any future major problems on OS X will be due to a trojan that gets sent out and manages to auto install through an exploit rather than a virus which does the spreading on its own.
The challenge for Apple is being good enough, fast enough to make sure trojan attacks are relegated to social engineering and tainted pirate downloads.
The Apple computer marketshare is small worldwide, but inside the US, one of the richer countries in the world, Apple has a much larger representation (+20% of laptop sales, +10% desktops), and almost all >$1000 computer sales. A bank account or credit card harvested from a random Mac is probably worth a whole lot more than a random Windows computer when selecting from a global set of computers. Essentially, wealth among computer users is not evenly distributed worldwide, and Apple products are disproportionately represented in wealthier nations.
One, Apple's market share has only been non-trivial in recent years, meaning since the x86 switch + the iPhone launch.
Two, most viruses and hacks use the Trojan Horse method, basically attempting to trick the user into giving you something that they wouldn't normally give you.
Three, even though Apple and its cult like to claim that OSX is secure, OSX automatically downloads patches, and Apple releases security patches nearly as frequently as Microsoft (but ironically isn't as diligent about closing security holes as Microsoft).
To make these work, the people attempting to harvest data or simply cause harm have to play the odds. So the 100 to 1 ratio between Windows and Mac machines out there has historically been reason enough to ignore the mac as a target for hackers and viruses -- so it's very likely that as Apple's market share grows, and as people start using iPhones and iPads for more and more of their computing tasks, they'll increasingly become targets for hackers also.