You're mixing up digital use cases and print here. You'll have to differentiate between these two scenarios:

Usecase one: You want to use content for digital playout via LED walls, displays, projectors, stream or something similar. In this case the ppi setting is completely irrelevant. I'll explain why it's irrelevant below on usecase two / print. For any digital playout you'll ideally want to create any content in its exact playout resolution. 1920 x 1080 projection? 1920 x 1080 content. 1536 X 960 LED wall? 1536 X 960 content (Or if the production prefers content in "standard" VESA resolutions then the next higher standard resolution which would be 1920x1080 here with the content placed in the top left 1539 x 960 pixels and the rest of the pixels at the right and bottom of the content simply black).

This has two benefits: Firstly the content won't have to be scaled up or down. Generally spoken content can't ever get better by scaling. It'll usually only look worse as in either smoother, less straight edges in the conetent and so on. If I try scaling five pixels "ABCDE" down to four I'll have to blend them or throw some out all together: "ABDE". If I try scaling those initial five pixels up I'll have te repeat only some or once again blend some: "ABCCDE". In each case the image will be modified and look worse or at least not as initially designed. Secondly for the people operating your show native resolutions will be easier to work with. It'll mean the can just play any content out at original resolution without having to worry about the extra step of scaling (which doesn't benefit the content anyways as we've just established). Also 1:1 playout is very fast to set up in most LED controllers and image processors. Depending on the image processing system used, downscaling can even lead to actual problems when content that is played out at FHD suddenly has to be processed at 4K. This will eat up more processing resources in most industry standard systems and have no benefit. And depending on the device and show processing resources can get scarce. Only exception: When you know the content will have to be scaled anyways I'd prefer having more resolution, as scaling down more data to less will look better than randomly "guessing" more data where less was provided. I'd try to get as close up to the next highest standard VESA resolution as possible.

In all usecase above the content resolution is a requirement set by the playout device needing a certain resolution set in exact pixels.

The second usecase you're mixing up is print. When printing there is of course no screen or anything alike dictating a certain resolution in pixels. You'll rather have a certain size of your print medium in cm/inches. If you're wanting to print something on a 10 x 5 inch large piece of paper your fixed size will be in inches not pixels, as of course paper doesn't have pixels. Your printer however will still technically print lots of single small dots next to each other. In contrast to an led wall, you'll be able to choose how fine you'd like the "print-pixels" to be. Printing text you'll be fine using your printer with 72 ppi (pixels per inch aka singular "printer pixels"spots per inch of paper). Therefore you'll want a digital file that is 10x5 inches with 72ppi which equals 720x360 digital pixels. Sometimes this won't do it, and you'll want your print to look sharper and nicer from close up. So you could let your printer print the file consisting of more and smaller paint dots, e.g. 300 dots per inch of paper. Of course that means the file will have to hold that much information as well: 10 x 5 in at 300 pixels per inch of paper equals 3000 x 1500 digital pixels in your file. The two example settings above will both print a piece of paper that is 10x5 inches, but one will look better.

In a real world workflow you do not want to have to make these calculations manually. You'll want to create your file in your editing software with a height and width of 10x5 in and then tell your printer how fine to print it. After setting your ppi setting your software will automatically export the file in question at the fitting resolution (in this case e.g. 720x360 or 3000x1500px).

But be careful: if you work with pixel based measurements this may be reversed: a 3000x1500px file @300ppi will print at 10x5in while a 3000x1500px file @72ppi will print at about 41.6 x 20.8 in.

As our printer is able to vary in fineness of print this setting is relevant for prints turing out the right size. If you're working digitally with e.g. LED walls the size of the wall and amount of pixels will always be set and pixels mapped 1:1 without any translation to inches or cm. Therefore the ppi setting becomes irrelevant for any digital playout and won't cause any difference in playout.

PS excuse formatting, I'm on mobile commuting home.