LED lighting fixtures for use in display, commercial, industrial, residential, and architectural lighting applications