Cinematic

can I do a good scene using ue4 […]

Yes, all the the things you mentioned can be done.

or I need another 3D software for the
scene

You will need assets. You can’t make them in the engine, so you will need modelling / texturing / animation software. Or, you can buy assets / get free assets.