I would spend the extra $15 on a MB with USB3.0 to be future-proof (like the MSI 870A-G46), and drop the 1TB HDD in favor of an 80GB or 120GB SSD for about the same price (I got my 80GB Intel 320 for $82AR), but other than that given the games you play the system Intel17 listed would probably last you a long, long time. If in a year your 250GB HDD isn't enough for storage anymore, you can always add a 1TB or 2TB drive once prices have dropped.
My current computer in the office is an E4500 (2.2GHz) with a passive HD2400 GPU running Win7 on 1GB ram (temporarily) but a 120GB SSD, and it feels plenty responsive. I wouldn't want to run a modern game on it, but it works great for Office, browsing and Youtube and it's almost completely silent. Image editing is a bit of a stretch if you have several large images open, but even with that the SSD removes a lot of the pain of going to the swap file. I'm really surprised you find 1GB to be such a bottleneck right now, my old computer sitting in my workshop had a 2500+ Barton with 512MB of RAM and XP SP3, and it had no problem with a couple big PDF datasheets open and running MPLAP IDE.