Perception is for observation, Investigation is for deduction.
Some of this answer will be observations on how Wizards has done it so far and some of this will be logic, and some of it will be mechanics.
First for the headline question. It depends. when to use Investigation, and when to use Perception is not entirely clear yet, and I'm hoping we'll get more guidance in the DMG late this year. The guidance from the rules is that the two skills mostly seem to differ in the methods by which they are found.
Depending on the exercise, either, or both of the skills may be used.
For passive checks, you're almost always looking at Perception being the skill of record. While all skills can be used passively, some skills make more sense than others. Perception is the hallmark passive skill, whereas investigation makes less sense as a passive skill.
If the character is alert to the possibility of hidden objects/traps, but not actively searching, he's using passive perception.
The guidance for this seems to be (though we can't confirm yet), that the DC for actively looking for something is regularly about 5 less than the DC for passively looking for something (or sometimes actively looking always reveals it).
So here's how I would play it. Traps can be noticed with perception passively (usually DC 15). If the PC is looking, ask them how they are looking. If it's observational, then use Perception. If it's deductive, use Investigation. When they are searching for items, again, either skill is appropriate. This is somewhat counter to how WOTC has written adventures so far. They are always written to use perception to notice traps. Passive with a higher DC and active with a lower.
Investigation also has broader uses such as when you are trying to track clues, or put something together. It's also a great "roll for a hint" kind of skill if your PCs get stuck and need some help figuring out what to do next.
Passive perception is exactly that, passive. It's what the PCs are always using when not actively searching for something and doesn't use a roll of the die.
To determine if you should use passive perception or allow a player to roll, listen to what they say their PCs are doing. If they say they are standing watch, keeping an eye out or something similar, they are actively searching so they can make a wisdom (perception) check, otherwise they are using their passive perception.
Although, it's kind of an experience call as the DM and depends on what the PCs are actually doing and whether or not the DM gives them the benefit of the doubt. In the case of the video, one guy said he was keeping a look out, thus actively searching and two of them were scouting off to the side of the road so the DM ruled they were also searching, rather than just wandering off into the bushes for no real reason, and allowed those three PCs an active wisdom (perception) check, whilst the others would be using their passive perception.
Best Answer
There isn't an official table
All we get is the typical difficulty class table that lists DC 30 as "Nearly Impossible".
There are very few examples that require high DCs. For DC 30:
For DC 25 there is:
For DC 20:
With Strength we have a reasonable idea. A DC 20 (Hard) allows you to slow a 40 ton boulder with around 2 tons of force. A DC 30 (nearly Impossible) allows you to push/pull with 4 tons of force.
Clearly even "Hard" tasks are far beyond all but the most exceptional of normal humans.
There are a number of skills that scale, for example jump distance or carrying weight per Strength score:
There are some high DC saves too: