Anything's possible. Check with your upholstery guy. He should have patterns & designs in stock that he's used before, if he's worth his salt!
Here's a couple of ideas on different methods I've used in the past.
3 dimensional.
Requires exact patterning & stitching over top of some fairly dense 1/2" foam, which is then cut away from the back in the areas not to be raised. I have as much time, if not more, on the backside of this as the front.
The pattern was taken from a picture of the logo, then expanded to the appropriate size. Printed out on paper, the logo was then cut out of that & laid out onto the vinyl where I wanted it.
You must be registered for see images attach
Then there is this style.
With this, I drew the flames onto the top material first. When sewing, I put a second piece of material under the area being sewn. Also back up with that 1/2" foam. After the stitching was done, the flames were then cut away to expose that second one underneath.
To get the color fade, I pre-dyed the second material in the fade from red to gold before sewing
The only prob with this, is that the raw edge of the top material is exposed. Evident be the white edges of the white backing on that top material. The customer wanted white outlines on the flames. Best idea that I could come up with!
I used a short stitch in order to lessen the chance of the top material being caught & pulled away from the second one. Intricate stitching needs short stitches. Requires a slow, steady hand when cutting out the flames after they were sewn so as to get a nice clean edge without any nicks or burrs. Sharp scissors, right to the very tip, too!
You must be registered for see images attach
This pic shows the white backing of that top material.
And...just for the 'Show-off' factor, (hehe!) check the piping around the edge of the seat.
Fades from red at the front, to gold at the rear & then around & back to red at the front again.
You must be registered for see images attach