Electrical – Are all ungrounded >120v outlets now outlawed

To answer all the issues you raise would require a book on US electrical wiring. Or several. And a copy of the Code.

The vast majority of outlets in residences in the US are attached to branch circuits that are rated at 15 Amps and 120 Volts. Current practice and code calls for outlets like these

This version is tamperproof, required in many jurisdictions. The non-tamperproof look similar, but the slots do not have internal baffles

You may see different styles, such as Decora, or decorator style, which are functionally identical to basic outlets, but have a rectangular face

20 Amp circuits generally require slightly different outlets (if you are going to draw the full 20 Amps or there is only one outlet on the line) like these

But you can also find the lower 15 Amp outlets on circuits that are properly wired for 20 amps. Obviously 15 Amp outlets are limited in use to 15 Amp appliances, even if they are on a 20 Amp line.

Certain locations, especially where there is a risk of moisture, such as bathrooms, require a ground fault interruper (GFI) type outlet

These also come in tamper resistant and 20 Amp versions and vary like the basic outlets.

All of the above are grounded outlets, required in almost every jurisdiction for new construction and renovations. Some older installations may have ungrounded outlets.

These generally cannot be used except as a direct replacement for an existing one, and even then setting up a properly grounded outlet is preferred and may be required.

All of the 120 Volt outlets require a hot wire (usually black or red) and a neutral wire (always white). Grounded outlets also require a ground wire (green or bare). Outlets can be always live or switched. Live outlets have the hot wire coming directly from circuit without interruption. Switched outlets have the hot wire going through one or more switches before reaching the outlet so that the power can be turned on or off.

All of the 15-20 amp outlets shown above are duplex, that is there are two receptacles for plugs on each. These almost always are bonded together by a strip of metal. When you wire to one, both are energized. This bonding strip can be broken off allowing each of the receptacles on the outlet to be powered separately. This is most often done to allow one receptacle to be always live and one to be switched. This also allows each receptacle to be on a separate branch circuit (for heavy power use).

Some residences use higher amperage outlets for large appliances, such as an electric stove or dryer, and the outlets vary base upon a number of factors. Examples can be seen in the chart linked in the question.

Similarly, some residences use 240 Volts for large appliances and wells, and the outlets also vary considerably, and can be seen on the linked chart.

This is a very brief summary of the type of outlets most commonly seen in US homes. The full range of outlet types and uses is beyond a simple summary. The range of possible switching and wiring configurations also is nearly infinite. But this site welcomes questions on any particular configuration or problem you may encounter, so ask away.

All of your symptoms sound like a faulty Neutral connection. Faulty neutral causes L1 to affect L2, and has no affect on 220 equipment just like you described.

Fix that quick. A faulty neutral can damage your equipment, and because you installed a second ground, it can harm YOU as well. Check that the neutral wire is firmly connected, and using Noalox:

ALL aluminum connections for that matter should be protected from corrosion and thermal expansion with Noalox.

You are lucky that you have a conduit! You have an EASY way to remove the entire length of the neutral conductor to inspect it for damage. You should also take advantage of that conduit to pull a ground conductor through it and use that to ground your sub panel VIA your main panel. Do not use a second ground rod at the sub. It is not worth the risk in your case.