Everyone is different, but for me strength training wakes me up, while cardio helps me sleep. What surprises me sometimes is how much cardio I need for good sleep. In one particularly high pressure week, I had to row (erg) 7-10km per a day to sleep well.
I'm similar. Without intense exercise, my brain is at high revs all day and I can't keep it under control to fall asleep. I need to knock myself out with exhaustion.
I used to run 50km per week or so and still feel like I could use more. Restless legs, active mind, fidgeting, etc. These days I'm running much less, but I'm lost without it.