Ok so it looks like per the NEC that the service entrance equipment must have a neutral bus if the system is grounded?
Not necessarily a neutral bus. Any service supplied system that is grounded the grounded conductor must be brought to the service equipment though and must be bonded to the service equipment enclosure. Grounded phase conductor of a corner ground system is a grounded conductor. Systems with a neutral conductor almost always are required to have the neutral grounded - therefore the neutral is the grounded conductor of those systems.
What about equipment (panels, switchboards, etc..) located downstream of the service entrance equipment? Do they need to have neutral buses or neutrals pulled to them if there are no L-N loads being served from them, or located anywhere else in the system?
Beyond service equipment you don't have to run a grounded conductor if you are not feeding any loads that utilize the grounded conductor. You must still run equipment grounding conductors - even with ungrounded systems.
So it appears if a system is ungrounded (ungrounded delta) then a neutral isn't required to be brought to the service entrance equipment, and the service entrance equipment does not have to have a neutral bus? What about a corner grounded delta? This is still a grounded system but does not have a "neutral" per say. Does service entrance equipment still have to have neutral bus in this case?
An ungrounded system has no grounded conductor to bring to the service equipment. If it has a neutral it very likely is required to be grounded though.
Neutral conductor and grounded conductors are often the same conductor but they each have separate definitions and different function sometimes. Not all systems have a neutral. All grounded systems do have a grounded conductor though.
Yes I see 3-Phase/3-wire in a lot of industrial systems. Usually these are separately derived systems located downstream in the plant distribution system. Can an industrial facility have a 3-phase/3-wire system but still require a neutral or "grounded conductor" and bus in the service entrance equipment?
I feel I have already answered this above.
What about at Medium voltage levels such as 4.16kV? Most of these systems are 3-Phase/3-Wire. Do the service entrance rules apply here as well?
If it is POCO system NEC doesn't apply. If it is not POCO then yes the base rules are the same unless you find something that says otherwise in the over 600 or over 1000 volt sections in the code.
4160 is usually line to line voltage of a 1460/2400 wye system. Most of the time however there is no neutral load so the 4th wire is just an equipment grounding conductor beyond service equipment. Should there be neutral loads then one would need separate neutral and EGC just like for lower voltage systems.