Personally I use Fedora; my workplace uses CENTOS and Scientific Linux so it's the same family. But Ubuntu is what most people get for desktops.
Re. viruses - Linux is no more secure than Vista. They both have user separation, attributed filesystems etc, but Windows has much bigger market share and better binary compatability. That means you can write a virus and it will infect all Vista computers, while you might write one for Ubuntu 10 and it won't run on Fedora 8 because it's missing a library. So in practice, right now, Linux does not get viruses because no-one is writing them, not because it is impossible.
I run clamav antivirus on a Linux mailserver so it can reject mail with viruses and keep the noise down, not because there's any risk.
One thing that has been running around is SSH password dictionary attacks. If you run SSH server so you can login from elsewhere (e.g this morning I logged in from my cellphone to find some insurance information I needed) then you need good passwords and preferably to disable network logins as root. One of the phone jailbreaks enabled SSH server but left a default root password, so people were able to just login and hack phones.
I haven't had much luck with multimedia editing, but I've not really tried. The support is better in Ubuntu.
Regular stuff wortks fine - Firefox, Thunderbird, OpenOffice, Flash, Adobe Reader as well as all the builtin progs like xpdf, ghostview, C++ compilers, Perl, Python, Java etc. etc.
I use mplayer for playing media which is pretty good though not the most friendly interface.
USB sticks, disks etc just work, digital cameras are mostly all supported natively, there's support for analog framegrabbers and some professional HDMI cards.
Program packages are a bit varied. Mostly you just download from Ubuntu using the graphic tools and it just works. Some commercial stuff they want you to click an EULA before installing and they do self-installing executables and strange (by Linux standards) things like that.
Other software you build from source by doing things like
"tar -zxf foo.tar.gz ; cd foo ; ./configure ; make ; make install"