I cannot know with certainty what medication would work best for you. Your doctor may be in the best position to adequately answer your specific medication questions. I can only give you a general answer.
You have never been psychotic and you do not believe the medication is helping. Because of this, an antipsychotic drug may not be needed. On the contrary, some doctors prescribe antipsychotics for nonpsychotic disorders and some patients have found them helpful. Results vary from individual to individual.
You mention the fact that you have gained a substantial amount of weight. The medication is also making it difficult for you to function at your new job. These are serious concerns which need to be addressed. If your doctor is not willing to alter your medication or answer questions about why you need to be on a particular drug, then I would suggest seeking a second or third opinion. Your doctor may be concerned about you relapsing, possibly attempting suicide again or trying to keep you out of the hospital. Those are legitimate reasons to continue prescribing a medicine but if there are negative side effects then alternatives need to be explored. If she is not willing to adjust the medication, then you may want to consult another doctor.
Based on your letter, it seems that medication is your only form of treatment. I would strongly urge you to consider psychotherapy. Medications can be helpful but in many cases they work best when the individual is concurrently in therapy. How would therapy benefit you? Therapy, for instance, could help you address the reason why you tried to commit suicide. There is a reason for why you attempted to end your life. It’s a very serious matter that should be explored in depth.
Therapy could also address issues related to decision-making. You stated that at least in part your current problems are related to prior bad decisions in regards to real estate as well as spending sprees. You and the therapist could explore what led to those bad decisions. He or she could help you to alter your thinking and learn how to make better decisions in the future. Gaining better decision-making abilities could be a very important step in improving your life now and in the future. No one can be free of mistakes but the goal of everyone should be to make as few as possible.
I hope I’ve answered your questions. I truly believe that therapy could be very beneficial to you. Beginning therapy does not mean that you have to stop the medication; you can and should do both. In fact, it should be a major component of your treatment. If you would like to find a therapist please consult this directory. You may be able to find a local therapist who can address your needs. I wish you the best of luck.