The proposed skyscraper was once seen as the successor to The Tower as Wales' tallest building