Many. The length is not necessarily a bad thing. It's whether you do anything with the length. Like a Rolling Stone and Hurricane are the first long Dylan songs that come to mind. They aren't draggy, needlessly repetitive, and continue to develop new lyrical ideas the whole way through. She's So Heavy and Revolution 9 do not.
Because does not use the same riff as Sun King. Give it another listen. You Never Give Me Your Money uses a melodic motif that is reused in Golden Slurabers and Carry That Weight, but on the whole it is a much stronger motif than the one used over and over again in Because and She's So Heavy. You'll also notice that those songs don't just hang on that motif the whole time. They all develop and move to different places.
There's also nothing inherently wrong about hanging out on the same riff or chord structure or motif or what have you for a whole song, as long as something is being coherently developed. Take the Funkadelic song "Maggot Brain" for instance. It actually runs a very similar riff throughout the whole song. But over that riff it develops a very emotional and beautiful guitar solo, so it's fine. But Because and She's So Heavy never really go anywhere and the lyrics are inane.
It's music criticism; it's inherently subjective. This all just my opinion, man. In general, though I think you always need to have something interesting going on in a song. My problem with Tomorrow Never Knows is that it throws away what the Beatles were best at - melody, harmony, lyrics - and doesn't really replace it with an adequate substitute. I don't listen to the Beatles for their avante garde experimentalism. That's why I listen to Ornette Coleman, Eric Dolphy, Brian Eno, etc. Avante Garde was not their thing. I listen to them because they were a great pop band.
It's not that it's a cover that I have a problem with and I'm not criticizing the songwriting on it. It's an ok rock song in like a Chuck Berry or Little Richard vein, but the Beatles have just spent the last forty minutes playing some of the most complicated, beautiful, and ORIGINAL pop music ever. To close with a cover that sounRAB just like everything they were doing two years before ... well it sticks out like a sore thurab.
First, this is a music discussion board. I'm sorry my music discussion offended you, but I thought that was the point.
Second, I absolutely LOVE the Beatles. I think they are the greatest pop enserable ever. But that doesn't mean they are infallible. The vast majority of their stuff is incredible, but I don't have to love everything to be a fan.
Third, I have listened to John's solo stuff. It bores the pants off me. This might come from my music major background, but John was really not that sophisticated a musician. The really sophisticated stuff tended to come from McCartney and Harrison. Without them, his music is just a pale shadow of what he was producing as a Beatle. As was McCartney's because just as Lennon needed him for his musical knowledge, he needed Lennon to challenge him and keep him from composing only syrupy bubble gum pop.
Thus the only Beatle with a worthwhile solo career is Harrison. And Ringo, if you count his tenure as the conductor of Thomas the Tank Engine and add the excellent song Photograph (which Harrison mostly wrote for him too) to the equation. But in all seriousness, really the only one to match what they did as a Beatle, and to continue to grow as an artist was Harrison.