Supported Metal Oxide Nanosystems for Hydrogen Photogeneration: Quo Vadis?