I'll be in minority and say:
Eh... I guess it was alright. Not on the level of Batwoman finale (seriously, that was dope), but alright I guess for what was portrayed this season (that is some nonsensical plots that led no where). I guess, the major thing to be taken from this finale is that Lena and Kara are back as friends and that Brainy sacrificed himself, because everything else Leviathan related... well... even more pointless (in the sense of why is it even here) as Alex wanting a baby sub-plot. To think they could have done much more with the whole VR addicts thing, but the show-runners decided not to... waisted potential... and still I have no idea what was Leviathan's end goal in all of this. As far as season villains go... they are even lamer than the tree idiots from the sixth season of Buffy. Waisted potential from Mitch Pilleggi as well. As I've said somewhere earlier, the show-runners are taking more and more liberties from Once upon a time show-runners, and this is not a good thing.
Speaking about Brainy... nope, I can't seem to find any good words for his character. For a supposed twelfth level intellect he's... yah... If I was him, I would have started to ask questions the moment where my alter-ego from another timeline came and said I have to work with a megalomaniac in order to defeat Leviathan, alienate all my friends etc. (Cause, this episode: "Oh, Brainy, you don't have to do this. You can help your friends". Really, bitch? Then what the fuck was all of that about after Crisis?)
Lex Luthor... I mean, I don't like him (this version at least). He's too... too... everywhere involved. At least in Smallville, that Lex version was more grounded in reality. This one... nope... straight out of Power Rangers. I mean, maybe... he's kinda better than he was in Season Four, because there was no over-the-top villainous moustache twirling, but... there was some over the top: "Surprise, surprise, it was me all along. I know you'd do that, cause I'm Lex Luthor. HAHAHAHAHA".
Anyways... I rate this season some where between a five and a six. WASTED POTENTIAL EVERYWHERE.