Well, I'm just a silly blonde, but I've upgraded my Mac's several times. So I don't know what holds true or not. I think *some* might be prejustice about Macs, especially listen to die hard PC users.
The main thing is: You can do *anything* you want on a Mac that you do on a PC EXCEPT playing games. Well you can play games, but usually they release the games late an they aren't well written and doesn't perform well on a Mac. And most real gamers get XBoxes or Gamestations instead, that's something that's made for games, regardless of what type of computer you use.
I play any music I want, any video I want, I can even EDIT my video I shoot myself with the application that comes with the Mac.
To view video or even edit video, you really don't need to buy a thing, iMovie comes with the Mac to edit video. To view video you use QuickTime or some FREE thirdparty applications, such has VLC, which can play ANY video codec there is on the market. iTunes plays your mp3's (and even other sound formats). iPhoto organizes your photos and you can even make some small adjustments to the images. iDVD, if you buy a Mac with a DVD-recorder, will let you make your own DVD's that you can play on the TV, give away to friend and family with pictures, movies etc.
You really don't need to buy any applications to get started with a Mac, most apps can be downloaded from the Internet as well, if there's something special you have need for. The Office 2004 package is great and written specially for Macintosh and some even say that it's a better package than the Office for Windows, some features you don't find elsewhere. Office you can pick up for student price if you are going to use it privately, even for those who are not students, as long as you don't use it professionally (i.e. earn money from writing or doing spreadsheets or Powerpoints or whatever).
I've been a Macuser for almost 20 years now, I got started using a Mac in 1985 and got my own about 1.5 years later. Never looked back since.
The new Mac OS X (now at 10.3.6) is a very stable system and one thing you really will love. Especially the fact that you won't find ANY viruses made for Mac OS X. The older Mac OS had about 40 known viruses, while Windows have what... uhm... is it even enough to say 40,000? Might be more now. *scary*
Well, if you have any particular needs that you're worried about, let me know and I'll answer any questions you might need answers to, or point you into a direction where you can find those answers.
Don't listen to those die hard PC users, even my hubby, who is a certified Microsoft technican likes Mac's. But he says Windows keeps food on our table.