> Especially before bed my mind wanders and produces these amazing Blues/Jazz riffs or Moonlight Sonata-esque ideas, but my talent is far behind my taste when it comes to either trying to play or even transcribing all that I "hear"... at least without significant manual effort.

Double down on ear-training, it'll take you a long way toward being able to being able to automatically translate the imaginary sounds into real play.