Middle-earth: Shadow of Mordor has an insane Ultra HD texture pack, with a requirement of 6GB of VRAM from your GPU. But, by the looks of a comparison between the Ultra HD texture pack, and High settings, there isn't much of a change in visuals.
The Ultra HD texture pack is a separate 3.7GB download, but when enabled, apart from requiring 6GB of VRAM, it doesn't seem to look much better. There are some comparison screenshots above, and below, which compare both the Ultra HD texture settings, and the normal High setting within the game, that doesn't require 6GB of VRAM.
In the screenshots, the top half is the High settings screenshot, while the bottom shot is from the Ultra HD texture pack enabled version of the game.