It depends on context. Imagine a couple arrange a date via a dating app (and have only seen photos and exchanged messages). When they meet in person, if one says to the other, "You're really photogenic!", that would be rude. It implies they look much better in photographs than in reality.
But generally it's complimentary. Anyway, photogenic people tend to look good in person too in my experience :)