Impact of Solid-Supported Cyclization–Elimination Strategies toward the Development of Natural Product Inspired Molecules in Drug Discovery Research