Let's write a memorable campaign intro together in 20 minutes.
https://www.kassoon.com/dnd/start-with-tragedy/
To be fair to the OP, I think he intends for the whole opening segment to be this kind of setup--for the DM to design a village tailored to catch both the PCs' and players interest by giving them tastes of what they would most enjoy. For example, he mentions that the wizard might be learning about some rare artifacts for sale in the market; I think there's an implied assumption that this is the kind of story that would really excite the wizard's player.I had far more interest from the same players in the campaigns where I considered the characters, the character motivations, and the stories the players enjoyed.... and built for those.
So basically, the OP wants you to dangle a campaign perfectly tailored to interest both the PCs and the players ... and then to cruelly yank it away to make them mad so that they'll want to kill his BBEG.
In Vecna Lives!, the players start the adventure either by playing the great mages of the setting or seeing what happened to them.
That always carries the inherent risk of making the players more angry at the DM than the BBEG.