Do all L shaped shower curtain rods need a ceiling support?

No. Some "L" shaped shower curtain rods have floor support which comes up and attaches to the rod. I have seen these types in bathrooms with high ceilings and also in bathrooms with large skylights in the ceiling.