The latest copy of Which? has Apple way out in front, and an iMac could meet of all your needs, with the exception of PC games.
2nd in the report were Dells, XPS 600N for gamers and Precision 380 for creatives - both have 1Gb of RAM.
Both Dell and Apple top the Which reliability tables.