My son also just turned 6. I went back and forth forever on his party. We did a big party last year with his whole class so this year decided to do something smaller. Anyway I tossed around some ideas of places I know he would like, such as Legoland, and was just going to do our family. But when I asked what he really wanted, he said a birthday party with his friends.
I also really didn't want a party at my house, but decided to do it for him. He got to invite five boys, and we set it up as a dropoff party so the parents didn't have to hang around. We did relay races, pin the smile on the skeleton, pumpkin toss, and I set up a treasure hunt for clues inside and outside that lead to a treasure chest-shaped pinata. They decorated their own cupcakes that I had baked. I spent very little and the boys had an absolute blast.