I made this.
It's basically a Jetson-esque hover car, modeled after a 2015 Honda Accord, and made for my final project in an 11-week summer course. I have to say, I'm only an average modeler. I'm better at texturing, but since I'm not much of an artist I use a lot of procedural or pre-made pieces. In any case, I know now that I'd be happy to pay other people to do this kind of work for my games. I think I already knew that, but now I know what to look for, what to ask for, and generally how to communicate with 3d modelers and texture artists.
Also, many of the best individual pieces of a game, like the character model for a FPS, and how it animates and moves as a cog in the overarching mechanics, stem from how the model is textured and painted. My appreciation for the time spent making this stuff has dramatically increased. As always, I think the process could be improved, but I have a feeling that most of the people working with these tools know that, and are actively pursuing better methods!
I also made this!