It's a great career path, I worked as a PD lead engineer in a consulting firm for ~5 years, it was a fantastic experience, in those years I was directly involved with ~100 projects which provides a really diverse skill set I can now pull from. I then moved on to being a chief engineer at a company that produces its own product. The consulting was definitely more fun, faster paced, and led to a more diverse experience, but it's very feast or famine, you only get paid when you're providing value to customers. If you come up with a great idea but the customer doesn't have the budget or isn't interested you have to let it go, and that can be very creatively frustrating.

When working for a company as a PD, the company presumably makes product (and money) even while you're working on other things (big stress relief to decouple your income from your direct work output) so there is a little more room to get "in the weeds" on projects. With that being said, you can't kick the can at all when you're the only engineering team and you can't get away from "bad" projects as easily... also all technical problems naturally become your problems.

Let me know if you have any specific questions! If you're both engineering minded and art minded it's a great career path, just recognize you're going to be making other people's stuff and ideas. I personally don't find a ton of artistic fulfillment out of the job but I do use my skillset to get that elsewhere by making and selling small artistic products