Based on Legolor's Earth Litophane Lamp 8" cut file (https://www.thingiverse.com/thing:4578198), added a bottom ring and put all together on rotating base.
I use spare 6V DC motor with reductor, fixed on base at position where 'gear' part (mounted on reductor's shaft - cca. 100 RPM) drives 'base_rotor' part. Any low speed motor can be used as long it fits inside base. Switch (20 mm) is used to turn motor on/off when power is applied, but just as an option - if you don't use it, motor will be turned on/off together with lamp. If you don't use switch just print 'base_upper_no_switch' part instead of 'base_upper'. Lamp socket is standard E14 (2.6 x 5.6 cm) with thread at bottom and I use E14 4.9W RGBW light bulb.

Preview: https://www.youtube.com/shorts/vwgqicwQLzc

Creality

Ender-3 V3 KE

No

No

0.2

30%

Use 100% infill setting for Earth.stl

1. Place bearing on central shaft of the base.
2. Attach motor power supply and motor to the base (position motor in place where "gear" will have good grip with "base_rotor").
3. Join "base_rotor" part with "thread" part by using 4 screws and place it on a bearing.
4. Mount E14 lamp socket on threaded part of base central shaft.
5. Mount E14 RGB lamp into the socket
6. Join "Earth" and "Earth_stand" part wih 4 screws and mount it on base.
7. Turn power on and enjoy!

8x - M4 screws
1x - Ball Bearing 6000-C-2Z
1x - Switch 20 mm (optional)
1x - Low speed motor (up to 100 RPM)
1x - E14 RGB lamp
1x - E14 lamp socket
wires