I drink a rather hefty glass of red wine 6 nights out of 7 and on the 7th it's either scotch or vodka. Am a fan of cabernets. Do like a number of the other spirits on your list but not enough to buy a bottle for home use. Haven't touched sherry in decades.
Pinots are my favourite reds - red burgundies in particular.
But burgundies (both red and white) are a crap shoot. The prices are through the roof and you can pay hundreds for a bottle of crap.
A well-known wine writer once said that great burgundies are the most expensive wine you can buy because you have to buy so many over-priced bottles before you come across a great one.
Thankfully my palate is less elevated
Sherry on the other hand is wine’s unsung bargain. Years of declining sales mean low prices.
Sherry range from the very dry to unctiously sweet.
There is a style to suit most foods.
Do try a glass of dry manzanilla or fino when you next have oysters or anchovies.
An amontillado goes superbly with soups, seafood or paella
And the unctuous PX (Pedro Ximinez) is great with a flan Catalan (crème caramel) or as a topping for vanilla ice cream