I find different exercise affect me differently. Not all exercise are equal.
If i cycle long distances or go on the indoor trainer (wahoo Kickr) i will get tired and sleepy in about 2-3 hours time so I've been quite successful with that plan on a sunday evening.
Working with weights doesn't make me tired for bed though - in fact i'm quite amped up.