Thanks to Reza for the tip. Others have flagged offers that are supposed to have no fee, but the fee waiver didn’t appear explicit on the offer’s web page. This one does.
Moreover, with the Worldperks program going away, it’s close to a last opportunity to get the card and signup bonus of miles which will be converted into the Delta Skymiles program.
23,500 bonus miles after $500 in spend is a good offer with no fee for the first year, just cancel before that year is up.
In my experience, by the way, the card is churnable — at least after some period of time has elapsed. I had a Northwest Visa card back in 2004 and had no problem getting a signup bonus again earlier this year.