Is it possible to paint or spawn in foliage that is rotated to point towards a certain point?

Just use the terrain normal for that… clicking align to surface option on the foliage should normally suffice