Opinions are one thing but facts are facts. A 45 foot rig will cut down on the number of RV parks you'll be able to use. But if your alternative is a 41 footer, then there isn't much difference. If a 45 footer won't fit then a 41 footer probably won't either. I've never seen a park with a 41 foot size restriction. I have seen 38 foot and 28 foot (if my memory is correct). So if you want something 38 foot or bigger, I'd say it really doesn't matter because you'll have the same restrictions. I purposely bought a 35' because I can get in to most places where I regularly camp. But even at 35' there's been places I can't go only because their bigger sites were already taken. Even if the park can take a 45 footer, they may only have a few spaces that big and they may be taken up.
Now for the good news, there are a lot of RV parks in California that can take a 45 footer no problem. You'll generally start running into problems in locations where land is a premium like some coastal areas and up in the mountains.