I was confused how a cursor might look to not be considered ugly or standard. I do like how cursors in games look and I am fine with them but when I create a cursor for myself there is something that doesn't fit. Is there a standard workflow or process to creating elegant cursor that are not standard?
A cursor can be anything (clown, wagon wheel, chipmunk, ... whatever)
The reason it's usually a pointer, is that you're generally pointing at things when interacting with your computer. Other than that, I've never seen any 'standards' on cursor design, it's more about aesthetics.
The only other thing would be visibility — you don't want to lose it on screen, so you want to keep that in mind. It needs to show-up well on whatever background you might have.
Design it well, and it won't be ugly, or standard. ;)