Worcestershire secured the Metro Bank One Day Cup title in thrilling fashion as Hampshire suffered final disappointment for the second successive Saturday.