It all depends, there's nothing wrong in upvoting yourself. But probably if you vote yourself over others (as I used to do what an a$$/le I was) people will notice this and probably your reputation will go down. We are all humans =)

EDIT: I want you to read @flipstar 's comment above to understand it better, I think his way of thinking is really good