PS4 DLC code and region

Out of the box, no. The Nintendo 64 has a region lockout chip which prevents NTSC (Japanese and US) games from running on a PAL (European) machine.

However, through the use of third-party devices, most games should work. I personally own a N64 Passport Plus which I use to play Hey You, Pikachu! on my own N64. It basically works by using a second, local cartridge to authenticate with the lockout mechanism.

I don't have first hand experience of this, but according to that Wikipedia article, some games won't work even with this - presumably, they perform additional hardware detection, so they might be hard to do anything about. It may be possible to somehow bypass these through Action Replay codes; I don't know exactly how these games perform those checks.

You could also buy a Japanese N64 and bring that home. You'll need a power converter to make it run on 230V, and a TV which will accept the input, but you could run any Japanese game that way, and any US game if you remove the plastic tabs.

As an alternative, if you have a European Wii, at least some of the games might be available on the Virtual Console, saving you the trouble of messing with adapters.

You've over complicated this.

For PS3, basically once a DLC was installed on a system, any user on that system can play that DLC and earn trophies for it, whether signed in to PSN or not, I've never seen DLC which is only usable by the buying user except for items like Home items, Avatars and DLC for one specific game I know of.

So your "process" is fairly simple:

1. Log into the appropriate store for your game's region (you'll need another PS3 profile with a PSN account in that region)
2. Buy DLC from that store (funds could be from a local credit card or prepaid PSN card) and install it.
3. Log back into your main profile and account and play the DLC.

PSVita is different. A PSVita system and memory card is locked to a single user, so even if you switched the Vita's user (system restore), you'd still be only able to download the DLC to a memory card assigned to the "foreign user", meaning it won't be accessible to your "main user" (which will need its own memory card), this means that in order to buy DLC for a PSVita game, you must own a copy of the game from the same region as your main PSN user. There's no current way to avoid this (at least one that I know of), and it basically means any PSVita game that has "required DLC" like online passes, UPlay pass, etc, will only be "fully playable" if you buy games from your own region.