He was good for some Romans, but bad for others. The optimates who opposed him in the Civil Wars certainly held a negative view. The people generally loved him, but he made too many powerful enemies in the Senate. Caesar was a great general and an inspirational leader, but he proved to be a very naive politician.
