I've always been struck at the difference between what an avatar looks like in a generator and what they look like in engine (To be clear I haven't seen EvE's generator). It can be really offputting if you decide to take some extra care and attention and get something which just does not look as cool!
With CQ, now that you can actually see your full avatar, it's the same as in the creator. If you've ever played APB, it's kind of like that minus being able to do anything useful with your avatar.
PVP is fun, if you're willing to put in a couple months of boredom. All you really need is a good pvp corp and a bc with meta fittings to be useful. Joining EVE University is probably a good idea to get on your feet and learn some basics. If you'd like pm me your email and I'll send you a 21 day trial :)