Drupal is easily the most flexible one from the ones I've tried. I prefer to have at least separate photo gallery (I use Zenphoto, it's great) but you can do it all in Drupal. I also prefer separate forums with phpBB (see www.poromenos.org for a Drupal installation and shameless self-promotion :P).