Are any questions asking for checklists appropriate for Stack Overflow, i.e. neither "not constructive" nor "not a real question"?
If the answer is "it depends", please explain with examples what it depends on.
Asking for a checklist is, in itself, not essentially nonconstructive. This question could have easily been revised to say "give me some suggestions" instead of asking for a "checklist," which is why I'm so perplexed you're caught up on the checklist-ness. Anyway, it's hard for me to imagine how such a question could ever be constructive, probably because once a "checklist" question has enough information to be constructive, it's probably not going to be asked as a checklist anymore.
Here's an example of one of my questions that you may liberally think of as checklist done right: Is git pull --rebase safe if you are in a centralized model and never push force?
Essentially I had "worked out" the checklist myself and wanted to learn if my reasoning was complete. If the OP in a checklist question had enough knowledge to know that there were exactly, say, 3 or 5 things to check for, then this may be passable - but you would note that in that case the OP wouldn't ask for a checklist, they would probably word and frame it much differently.
But raw checklist? Facilitates a lot of incomplete answers, voting based on which answers one likes rather than which answers are correct, etc.