If you found Schopenhauer's thoughts on it interesting, I'd recommend giving The Birth of Tragedy a read to see where a young Nietzsche took it, relating it to poetry.