I have lived in the North Ed of Palm Springs myself- I have been selling homes in the north end for over 8 years. The wind is something to consider. There are some buyers that refuse to look at anything north of Vista Chino. Likewise, I have buyers that aren't interested in South Palm Springs either, because they think it is too far from the downtown.
Prices, however, are typically lower in the north end compared to comprable properties in South and Central PS. So its a matter of compromise. If you're looking specifically at a mid-century home, Racquet Club Estates is a phenomnal historic mid-century neighborhood- prices here have actually sold higher then similar homes in Central Palm Springs, because this neighborhood has really evolved over the years. Buyers will pay a premium for an architectural property. Because of the affordability of many homes in the north End compared to other areas, I don't think your resale will be specifically affected negatively.
As far as the wind, it is not constant. The main windy months are when the weather patterns change- in the fall and late spring. Most people buying a 2nd home in Palm Springs, aren't here during those months anyway. There may be other days throughout the year that are windy, however, it could be windy all over town, just the nature of the desert. If you're buying in a built up neighborhood, however, there usually isn't that much sand. However, if the house you are buying is adjacent to the open desert, sand will be an issue that you will have to deal with. Some clients actually LOVE living in the North End- the wind will keep your pool cooler in summer months. You also tend to have less bugs in the north end. The views I think are the best in the valley, in the north end of town because you can look right up the canyon where the tramway goes. There's also a lot of development going on in the north end, including the newly renovated Riviera Hotel which will be a hot spot for Palm Springs. Additionally, the Racquet Club is being restored with the reopening of the famous Bamboo Room. Historically the major resorts in town were built in the North End.
Best of luck with your decision. And I'll be happy to answer any additional questions, as well as give you a list of clients to contact that live in the north end, to get their own personal experience.