I've been in lighting for 40 years.
Use 3000K color for most 'residential' uses. Looks like incandescent/halogen.
Use 2700K if you want a warm lamp feeling, not candles but like an old table lamp. Anything lower is a 'special effect'
Use 3500K for a brighter, clearer look. Very popular in contemporary looks and hot climates. (Truly tropical climes like even cooler 4100-4500K.)
Don't use 5000K+ without careful thought.
But don't mix colors within a space. Having your kitchen area look blue while the seating looks yellow is really ugly.