ZyloxDragon: If you can find a copy of it, Drakkan Order of the Flame. Ground combat can sometimes be a little wonky, but you do get aerial combat on a dragon, similar to good old Descent.
I started bidding on a copy on eBay :P Game looks really awesome! Thank you for your suggestions :D
Strijkbout: If I may recommend something newer I would certainly try M&B Warband, I put over 500 hours in it (original M&B + Warband combined).
From the time period, Tomb Raider 1+2+3. If you can forgive these games that they're early 3D games with tank controls they're a lot of fun, a great experience even.
Fade to Black, one of the earliest 3rd person games, generally considered not as good as Flashback (rightfully so), I still liked it because it had atmosphere.
Aurora Watching or Soldier Elite depending where you're from, a solid attempt to copy Metal Gear Solid :) and I have a weakpoint for games where you have to infiltrate secret bases in the arctic.
Thanks for the great suggestions! Fade to Black really caught my interest and I think it might be about time I started on the Tomb Raider series.
Lifthrasil: My favourites have already been mentioned. So I can only repeat the recommendation in order of preference:
Max Payne 1 & 2, especially the 2nd is awesome!
Jedi Knight: Jedi Academy
Mafia
Outcast
Overlord
All the Tomb Raiders
Bloodrayne 1 (2 is meh)
Or if you also include role playing games, then there is of course:
KOTOR 1 & 2 (especially the first is great)
Edit: also really awesome, but published later than your 'time of publication window':
The Witcher 2 & 3 (especially 3)
Bunch of great choices in your post man, thank you! Imma try to grab Max Payne and Blood Rayne :D
Hikage1983: Noone has mentioned
Oni yet i see.
Unfortunately, your best bet would be tracking down a physical copy since it is not sold anywhere digitally (for shame too).
Wishlist entry:
https://www.gog.com/wishlist/games/oni EDIT: Gave up on trying to post the wikipedia link, thanks forum software!
Oni was an awesome game dude! I actually still have my ps2 copy :P Thank you for your suggestion :D
huppumies: Ever tried Outwars? Fits the bill I think, and it's an awesome game.
No, I have not tried it :O But from the pictures and videos I have looked up, it seems likes its right up my alley :D Thank you dude!