While I have shot a couple jobs over the years, like @BlueHeeler , my regular (non-flying) job keeps me busy. I like the cinematography aspect of it myself. It is mainly a hobby since at this point unless you're doing something like mapping or...
These days I really only use my drone to take aerial panoramas for me but it's absolutely worth, I love being able to see familiar sights from a completely different angle and it's a fantastic way to capture new sights.
My answer to that it it all depends on what you want to get out of it you don't need to blow the bank balance to make really good video and take amazing pictures but obviously there is a reason some drones cost hundreds of $/£ and others cost...
Considering all the time, effort & money invested, has being a drone pilot been worth it? There are some people who make money with their drones, but for most it is just a hobby. Is it a really cool flying toy? A flying platform for taking video...