When does dog ownership become rewarding?

My puppy is pretty good. He is 13 weeks old, medium size, and is doing well at potty training, commands (unless really distracted), and he sleeps in his crate throughout the night and for enforced naps. He even walks on a leash okay (for treats) and has learned sit, down, wait, leave it, drop it, come, and place.

He doesn't like his crate. He cries and yelps and beats the walls for at least a few minutes EVERY time we crate him. His crate is comfortable and covered. He gets a toy and a chew. He just hates being separated from us. I feel bad locking him up for 18 hours for rest (not at one time) but he WON'T self settle and goes crazy if he does not nap after about an hour or 90 min max.

I am getting kind of fed up with dog ownership despite having a pretty great puppy he is SO needy and just exhausting all the time. I am SO tired. Every time he is crated I ALSO want to sleep for two hours. I don't feel a gush of love. I feel like a treat dispenser who sometimes gets overwhelmed and yells.

When will my pup be HAPPY? When will he cuddle instead of biting me when I try to hold him? He has moments of really good behavior but when do the good moments outnumber the constant corrections? I wanted a happy animal to go places with me and help me be less lonely and get outside more. I didn't realize all dogs come with NO manners and have to be conditioned for every single desired behavior every moment they are awake. I didn't realize a dog "loving" me would feel like I forced stockholm syndrome on him.

For people saying 18 months… I wish I had known because I would not have gotten a dog. He is cute and sweet and easy for a puppy from what I read here but I think about life without him often. I miss silence. I miss sanity. I miss doing what I want.

I imagined owning a dog would require having a routine, multiple daily walks, picking up poo, vet bills, and training. I don't find any of that trying. But puppy rearing is killing me. I am just constantly on edge and anxious and so so SO tired. I don't know if I will make it to 6 months much less 2 years. I just want my puppy to be rested and content more often than not and not be SO much ALL the time.

How do I feel more positive about this whole experience? Does it ACTUALLY get better? Really? Or do you just get used to it?