mettelus
Johnny's point about PUPs is accurate. As long as you play a guitar (physically use it) and it is solid, made properly, and has a fully adjustable bridge, PUPs and wiring are the only real variable requiring "replacement"(and a fun playground for those who enjoy it). If it satisfies your creative needs, that is what matters most.
I have yet to sell any equipment and would never consider a guitar an investment, but realize there are some who consider this.
Dead on, on both points.
I tend to buy MIM Fenders (3 of them at the moment), and replace the pickups. To be even stingier, I buy USED MIM guitars and basses. Then I've upgraded the pickups and bridges in all of them, and they sound and play better than anything else I've bought. And all-in, probably $500 USD for each.
I also have a Yamaha TVL guitar. Yamaha quality has really improved in the last decade!
And like Mettelus says, i don't buy them for investment. You've really got to get into high-end instruments before resale value would make a significant enough difference to be worth what you pay at buying time.
From the 3 links you gave, the Squier link didn't work for me.
Between the Yamaha and the Mitchell, they're very similar. The Mitchell looks a bit nicer to me (i like the sunburst), but Yamaha is a known model which I expect will play nicely. But since you've played a Mitchell and liked it, that may negate the playability.
At that low price-point, re-sale value shouldn't really matter. You'll probably get 50% of the new price for either of those.