I take Elvanse, it's lisdexamphetamine and lasts about 8-10 hours. It's fabulous!
The very first day I tried meds (methylphenidate) I tried to describe how it felt. Inside my brain had always been like living in a 2 bed terrace house owned by a hoarder...just so much stuff...I took the meds and half an hour later it was like walking into an empty warehouse...it was really odd, kind of echoey... and I wasn't sure I liked it at first...it was so quiet!
Within a couple of days I realised the benefits, I can hold an entire conversation and remember what I and the other person are saying, I can finish jobs that I start (I still sometimes have to push myself to start at all if I am not keen on what I'm going to do, but once I start I finish!) 
I have implemented a new little job each day to do round the house and I am still doing them since January 1st 
, my house looks lovely.
I used to have a really rubbish diet, far too many carbs and 8-10 cups of coffee every day... not good as I also have type 2 diabetes... and now I drink decaf coffee, eat normal meals, normal snacks and don't binge eat in the evenings, I have lost about 7 kg since I started meds, am almost down to my 'ideal' weight and I am doing my 8000+ steps most days 
I tried methylphenidate first but it was too 'up and down' for me, Elvanse is smoother, and as long as I remember to eat enough protein it lasts all day. I am productive, happier and more able to be myself I feel much less like a hamster on a wheel in a sinking cage these days!
Have a look on medicinesforchildren.co.uk at the different types of ADHD medication and if you think about what you are hoping for from meds, you might know which may help you more. Talk to your medical professional though as there are reasons why some meds are better than others for different people. There's mostly a choice between stimulants (either methylphenidate or lisdexamphetamine based) which work for 70-80% of people and are usually the first choice for that reason, or non-stimulants eg Stratterra. There are others but usually it's between these three in the UK I think.
Everybody is different, my ds takes methylphenidate and it helps him focus and feel able to concentrate more at school, my dd is now also taking Elvanse and it suits her well too, although she does have more difficulty sleeping if she takes it after 8am (she has always had trouble with getting to sleep though).
The only negative side effect I had was a mouth like the Sahara desert for at least 4-5 weeks, particularly every time I went up a dose, but I just drink more now and it has worn off.
Good luck! It's really good your dh is supportive, I am hoping my husband sees that I am so much happier now and comes to terms with the new organised me!