I learned in college (1977) not to work on something just before going go bed. I was taking my first semester of FORTRAN and wrote out all the code for a programming assignment late one night with the intention of going to the data center the next day to type it in, run it and debug it. When I went to bed I closed my eyes and proceeded to debug the program in my head and could not get to sleep. I had to get dressed and go to the data center that night to finish the assignment so that I could get some sleep.

Perhaps I should get you to mentor me with my personal statement for University!

It depends on numerous factors.
Generally, it's not out of "excitement".
Usually, if it happens, it's out of anxiety over perceived unpleasantness that
is in the offing.

Mindfulness works for me. I have a CD of exercises where a person with a mellifluous voice guides me through a series of thoughts leasing to the now. Works every time.

Oh... enjoying life to the fullest.

Yes, many times.....

Not for a long time.

Looks like an evening nap is in the works.

I always enjoy a nap before bedtime.

I can't sleep if I am excited about the next day-a trip, seeing an old friend, moving, etc.