Umm, I've been on depakote - sodium valproate, didn't aid sleep or keep me feeling calm. It MIGHT work that way for some people, but it didn't for me, and I can't be the only one. OP, as I have discovered, there's no single magic pill for bipolar, what suits one, doesn't suit another. Also you gotta give the meds time to see if side effects become tolerable or you have another episode etc.
There's lots of meds anti-psychotics - newer ones like quetiapine and olanzapine - older ones like chlorpromazine (newer type are supposed to have more tolerable side effects, I personally found the reverse to be true). Sodium valproate. Lithium carbonate and citrate. There's loads. You could try one med, then have another added. Something else thrown in temporary. It takes time, it's annoying, you feel like a guinea pig. However, the main thing is you're willing to accept medication and counselling, so you should have a say when you really don't like something. But as you're finding out it can be hard to be heard. As the others suggest, take someone with you, explain it's not that you don't want to be medicated - you just want to try something else that may be more effective for you with less problematic side effects. I did the whole I just won't take my meds shit, that'll show 'em. It worked that I got a change of meds, however needing a 'guardian' at age 27 was a pretty high price to pay for 2 weeks of mania that I can't remember. Do it the rational way, please.
Also, bear in mind, I didn't get this for a long time and thought the meds weren't working, you're still liable to get episodes on medication, however the medication should make them less frequent and less severe.
Finally, stims do put you at more risk of triggering a manic episode, but I'm not gonna lecture cos I know the risks and still abuse them.