I know exactly what you mean. I think you do not mind the idea of a product like SharePoint, but you really hate the way it is implemented and how problematic it is. I know his nightmare for work.
As a C # developer, I compress when I hear the word SharePoint, SharePoint - Lord Voldemort. But, unfortunately, this is due to the fact that he is a senior C # / Microsoft developer.
I say, unfortunately, because most likely, if you work in a corporate structure sooner or later, you will have SharePoint in your solution. Not because it's good, but because, as others have said, MS uses SharePoint as a Trojan horse to get and maintain a business.
Perhaps there is hope for a new version of SharePoint (2010). Perhaps this finally includes a better programming / implementation model.
Otherwise, either work in small companies (usually less, but not always), or try, if possible, to use your skills as a MOSS developer. Never actively sell them if your salary does not depend on this. Remove the skill from your workshop and cancel jobs that are fully focused on MOSS. Some MOSS integration here and there you can live. The entire MOSS-centric solution will put you in a crazy state.
If all else fails, learn languages other than Microsoft, and within a year or 2, SharePoint will be just a faded memory.
I know many developers who are thinking about abandoning IT because of SharePoint. I would say not to let this end your career.
And finally, bitch and moan, and let managers know weekly / daily about why you are struggling in SharePoint. Let them know and constantly remind them how bad the technology is.