Will it work for custom post types like courses or products?

Yes. You can create images for blog posts, pages, course pages, and eCommerce pages, then set them as featured images the same way you would for a normal post.