I have textured ceilings, similar to stucco but not as rough.
Popcorn ceilings can be a DIY removal to make it affordable if you're handy. It's similar to stripping wallpaper.
Texture can cover a lot of imperfections so be prepared to patch, tape and sandpaper as needed.
I LOVE @SilleeMee 's idea of adding some sparkle! I had some glow in the dark stars on DS's bedroom ceiling when he was little.