He would like this cantrip (the lowest level magic in the Game) to do things like instant walls > negating ranged attacks, or instant fog > granting mass invisibility; that kind of thing. He would like to bring back the heady days of our teen years where an illusory pit could kill if the target thought it was real etc, etc, etc.
RAW I have used it to put up walls inside a window twice, once out of combat so I could look through it and watch the room behind. A second time in combat, and it was really unique. We had an enemy spellcaster who was blurred and behind cover and there was 0 chance I was going to hit him with my Eldritch Blast. So I put up an illusory wall. I could see him, but he could not see me so I got advantage to cancel the disadvantage. It would not "stop a missile" though. The DM ruled he knew it was an illusion as soon as I fired through it, but still said he would need to take an action to see through it.
I have also used the sounds a lot.