I don't use seasonal psalms. I only play for Sunday masses and always use the psalm of the day. That's what the pastor said to do.

I never use seasonal psalms.

We sang a psalm last week, IIRC, that no one in the cantor corps knew the words to, because last time it came up in the 3 year cycle it was bumped by Transfiguration, and the previous time was under a different MD who would have sung the same psalm every week if he were able.

I am thwarted in the use of any other propers, so even if it is English to a psalm tone, I won't budge on the psalm of the Gospel acclamation.

(Save the Liturgy, Save the World)

I am not condemning seasonal psalms. We don't sing psalms at daily masses, in fact there is no music. On Sundays, they are not replacements for the psalm of the day. Besides, the pastor won't permit seasonal psalms on Sunday.

Good music, well done, never causes people to get sick of it.

I haven't had time to reply, but since Noel wants data:

At my last parish, I used them for the communion psalm (a practice I've explained and promoted ceaselessly here), and for school Masses where the psalm of the day was not set to music.

At my current (Episcopal) church, the pastor would like me to institute sung responsorial psalmody, so I'm going to look into using a seasonal psalm as an option (or the antiphons as found in BFW)

And my opinions, without explanation:
I encourage their usage where parishes are transitioning from spoken psalmody to the preferred responsorial model, as an "in between" practice.
They are useful as substitutes for the minor propers, where necessary, and make a better substitute than a hymn.
I wouldn't consider them ideal for the between-readings psalm, but they're better than reciting it.
I don't get the scorn heaped upon them by so many forum members.

In the late 1980's to mid-90's we'd occasionally use a seasonal Psalm during Advent/Christmas/Lent. Since then Psalm of the day, strictly. OCP is in the pew, but we're working in more and more of the Chabanel Psalms (thank you once again, Jeff O., R. Rice, et al).

Like others, I use Psalms such as settings of Ps 34 during Communion. Since we have both Ritualsong and United in Christ in the pews, there is plenty of choice for Ps of the day. Before I came (18 years ago) the Seasonal Psalm was being done. I found that appalling, so changed it as soon as I had the authority to do so, and now the congregation knows most of those settings and sings them rather well. I also attend my own Episcopal church in the summer, and the congregation there sings easily a simplified Anglican chant antiphonally with a cantor singing from the choir loft. But then they have had the same Organist/choirmaster for almost 40 years and have always done it that way. In fact, this Sunday the congregation sang every single hymn lustily, even the difficult Eric Routley hymn 'Litton' Sigh.