I do feel like third person is probably best if you yourself are unsure, just because it's so flexible, although second does have its charm for a certain brand of self-insert porn game. You've identified one of the core limitations of first person, and pretty much the reason most novels are told in third person, which is that most plots require moments where you step outside of the MC for five goddamn seconds in order to develop other characters
First person works primarily for heavily personal, internal character developmenty psychological stuff where the character's mentality and perspective on the world is so important to the narrative that it takes front and center by effectively
becoming the narrative. You could argue that, from this perspective, first person is when a single character vores the entire narrative structure.
Second person is like First, only you have no 4th wall, and it tends to make the entire story feel like a CYOA gamebook to people over a certain age, or just like a really awkward roleplay to others. This is a blessing and a curse. On the one hand, it can be very immersive by means of self-insertion... on the other hand, it can be powerfully alienating for the same reason. It works so long as your assumptions about reality as a writer, and the reader's assumptions about reality, align. Otherwise, it's just first person with an extra cognitive step, where 'You' in the story is their own separate character from 'You' and... it kind of falls apart.
Third person is the most flexible, I think, in that it can either be tied to a one character at a time (third person limited) or be a floating perspective that may have insight on anyone present in the story, and even 4th-wall-breaking knowledge of the story scenario as a whole (third person omniscient). Limited works largely like first person, but with the option to follow someone else for a bit, like when GRRM changes character every chapter. Omniscient makes developing the villain of a fantasy story (A famous problem for doorstopper fantasy books), for example, dead simple. Because you can literally just
give insight on what they're doing whenever it would be spicy to know that their plot is moving along... but also can at worst put you outside
anyone's perspective and give you no insight on any of them beyond the surface level.
Honestly though, whichever one does what you want it to, that you can also write.