I have seen and read almost all the posts here and there are a few things to consider. Mostly what went through my own mind when I switched and what finally made the decision.
1. Glossy/Anti-Glare. There are screen covers/protectors that can make the glossy anti-glare. Would I recommend it? If the laptop will be traveling a lot, yes. If it will only be taking short trips around town, not really. The option is there. Make sure you read up on them, some can be taken off easily, others you may be stuck with.
2. Compatibility. Especially with the video files. Don't worry about it. The final feature that made me get my MBP over the Win7 box I was looking at was that I could use Bootcamp to dual boot to Windows 7. For me, this was a must for some software I use.
3. Mail. So long as the mail services you are connecting to offer IMAP as a way to connect, then you will be fine and you will be able to manage as many as you need. For me, I have all my mail from different services filtered to a single Microsoft Exchange server I have and I use Outlook 2011 (for Mac). I have had that server for going on 6 years.
4. RDP. Pie. In fact, it is nothing different that using the RDP software on every Windows box. Something to consider,
http://www.logmein.com is a free service that is both secure and stable and will easily allow connections from anywhere there is internet connection. Even if you have all the ports forwarded and whatnot, this makes managing the remote desktops in your network pie.
When it comes down to the software and such for photos, video and music, iLife with its range of apps are easy to use and will take you pretty far. Aperture, which there is much debate about on this site, is a decent enough app and is $199 at the time you get your Mac, or $79 if you get it through the App store. It is a much beefed up version of iPhoto, more along the lines of Adobe's Lightroom. I got Aperture in order to do some quick edits without needing to reboot to Win7 where I have CS3 installed.
Anyways, just some thoughts from one who made the switch not long ago. I have been a Network Engineer my whole career (16 years now) and being used to different OS's, learning OSX was both easy and fun. Still a long way to go, but I am comfortable enough with it.