On 8 May 1719, Hopson was promoted to rear admiral of the blue, and hoisted his flag aboard the Dorsetshire. In this post, he followed Norris on three more expeditions to the Baltic, in 1719, 1720 and 1721.[2]
He was further promoted to be rear admiral of the red on 16 February 1722, but does not appear to have been actively employed until 1726, when he took a small squadron to Gibraltar, where he joined up with another squadron under Sir John Jennings to deter possible Spanish aggression. When Jennings sailed home, Hopson took over command in the Mediterranean, and was promoted to become vice admiral of the blue on 19 April 1727. With relations with Spain descending into a war, Gibraltar was reinforced by six ships under Sir Charles Wager, who took command of the post. Hopson served under him in the ensuing siege of Gibraltar.[2]
In December 1727, Hopson was ordered to take command in the West Indies, which had been left without an admiral following the death of Sir Francis Hosier that August. He left Gibraltar aboard the Lion on 17 December, and arrived to become Commander-in-Chief of the Jamaica Station on 29 January 1728.[2][4] During his passage across the Atlantic he was promoted to vice admiral of the white.[2] On arrival, he transferred his flag to the Leopard and continued the Blockade of Porto Bello begun by his predecessor. However, like many others in the fleet, he succumbed to tropical diseases and died on 8 May 1728.[2][3]
His will, dated 13 April 1720 and proved 27 July 1728, mentions his wife Jane and one son, Edward, who was still a minor. It also mentions his mother, who was still living; and a widowed sister, Jane.[5]